Gather Schema and Tables Statistics

Gather Schema and Tables Statistics

Gather Schema Statistics – Concurrent Program 
Connect as System Administrator
Request – Run
Select - Gather Schema Statistics

Click OK button

Estimate Percent: Using any value larger than 50 will force a compute statistics to be
gathered; any value less than 50 only provide estimated statistics. Computed statistics in
some cases could provide a significant performance improvement for Application
modules.
Click the Schedule button to schedule as per your company needs, As a general rule,
schedule the Gather Schema Statistics concurrent program to run once a week, during off
hours, for your entire database

Gather Table Statistics Concurrent Program 
If you have volatile tables that are updated, inserted into or deleted from frequently, then
you should consider running Gather Table Statistics for those tables more frequently,
perhaps nightly during off hours. In the following figure, we’ve chosen a particular table,
FND_CONCURRENT_REQUESTS, and selected 99 for the percent to analyze to ensure
that the table is analyzed using compute, rather than estimate.

Note- Using these two Concurrent Programs also generates statistics on the associated
indexes.