Is it possible to analyze a single partition of a table? When I highlight a partitioned table in the schema browser and hit Analyze table it has one whole table listed to be analyzed. Is there a way to have it list each separate partition of the table as its own separate object to analyze?
Currently there is no way to analyze only one partition of a table.
Waiting for fix to be released in a future version of Toad for Oracle.
In versions prior to 9.5 you are able to analyze a single partition of a table.