Return
-
Title
How do you analyze a single partition of a table? -
Description
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?
-
Resolution
Currently there is no way to analyze only one partition of a table.
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle. -
Defect ID
QCM34042 -
Additional Information
In versions prior to 9.5 you are able to analyze a single partition of a table.