Analyze All Objects
Starting with Oracle 10g, the database query optimizer has switched to being entirely cost-based (instead of rule-based, as was the case in Oracle 9i and earlier versions). That means that gathering accurate and up-to-date statistics and histograms has never been more critical than it is now. Whether the focus is your application’s queries, third-party database applications, or even a tool like Toad, obtaining proper statistics is now a high-priority database administrative task. Luckily, Toad offers the Analyze All Objects screen to simplify that duty.
To launch the Analyze All Objects screen, choose Main Menu → Database → Optimize → Analyze All Objects. The screen shown in Figure 9.31 appears.
FIGURE 9.31 Analyze All ...
Get Toad for Oracle Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
