The statistics calculation method recommended by many is actually the DBMS_STATS package. Search this blog for examples of DBMS_STATS.

Analyze a table with a percent estimate:

*ANALYZE TABLE X ESTIMATE STATISTICS SAMPLE 10 PERCENT;*

Analyze a table partition:

*ANALYZE TABLE X PARTITION (Z) COMPUTE STATISTICS;*

Analyze a table partition using a percent estimate:

*ANALYZE TABLE X PARTITION (Z) ESTIMATE STATISTICS SAMPLE 10 PERCENT;*

## No comments:

Post a Comment