Hi,
Does Oracle has any tool or utility which will advise on Indexes needed ?
The statspack report does show all the Top SQL and other info, but wondering
if there is any tool which can point to us and give some recommendations like:
"following columns are used a lot in a period of 24 hours and would be beneficial
to add indexes to tables A,B,C. If it can advise us on the columns as well it will be great"
And please let us know if those tools work on the following
database editions. We don't use Enterprise Edition
Oracle11g standard edition ONE
Oracle12c standard edition TWO
Oracle12c R2 standard edition TWO
If Oracle native tools doesn't have any Index advisor are there any 3rd party tools ?
Thanks in advance.