Is there an option to auto optimize with indexes in SQL Optimizer?
Is there an option to Auto optimize with indexes? Auto optimize is more efficient because it does alternative generation while executing alternatives. Why not do the same for indexes too? And same for just indexes.
Make it a drop down: auto optimize rewrites, auto optimize indexes, auto optimize rewrites and indexes.
Enhancement Request ST70741 has been submitted to Development for consideration in a future release of SQL Optimizer.