When I run the index generator in the Optimize SQL tab, if I do not have the Create Any Index privilege granted to me, I will get a message that says no indexes were found that could help and to increase the intelligence level and try again. If I have the privilege granted, it would have returned indexes for me. I would like to see SQL Optimizer notify the user that they do not have the Create Any Index privilege, which is necessary to run that feature, instead of making it look like there is no indexes that would help optimize the statement.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center