Indexes types recommended in SQL Tuning Advisor
Fábio Prado, December 12, 2016 - 4:51 pm UTC
Oracle docs says that SQL Tuning Advisor suggests indexes, but does not tell you what types of indexes. STA only suggest btree indexes?
December 13, 2016 - 2:15 am UTC
That is my understanding.
The decision on bitmap versus btree involves more than just sql statement being tuned (eg concurrency, transaction volume, etc) so that is a decision that will require human expertise
link is not working
Amir, November 10, 2017 - 11:14 am UTC
November 14, 2017 - 1:34 am UTC
Thanks, I've updated it.