Compute mode generating script missing compute clause when Analyzing Table.
Steps to replicate:
Open schema Browser.
Right click on a table and select Analyze table
Select Options tab
Select radio button, Use DMBS_Stats
Select radio button, Mode compute
Select the tab, Table
Click the red triangle, Build Run script
Paste clipboard into Editor
The Compute line is missing.
There should be a line like:
Estimate_statistic => null
WORKAROUND:
None.
STATUS:
Issue fixed in version 9.5. The latest version of Toad for Oracle can be downloaded here.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center