Toad World® Forums

Optimize Index For Table Stored in Central Schema


I am using Optimize Indexes to gather SQL statements from the AWR logs to try to identify possible improvements by adding indexes.

I have about 120 different user all submit SQL against tables in a central schema. What I would like to do is analyse all the SQL statements submitted against the central schema.

The only option I can find is “Collect SQL for parsing schema” but I want to collect SQL for target Schema. Is this possible?

Many thanks for any help

Thank you for your suggestion, we will consider it as our future enhancement.