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.
WORKAROUND:
None
STATUS:
Waiting for enhancement to be included in a future version of SQL Optimizer.
Instead of having the Create Any Index privilege, you can grant the user an object privilege for the object you want the index to be created on.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy