Q
Problem solve Get help with specific problems with your technologies, process and projects.

Estimate statistics sample value

In the command "analyze table emp estimate statistics sample 30%" how do I come up with the value, e.g., 30%?

In the command "analyze table emp estimate statistics sample 30%" how do I come up with the value, e.g., 30%?
There's no standard formula for determining the estimate percentage when gathering table statistics, whether using ANALYZE or DBMS_STATS (by the way, you should look into using the latter, since it has superior functionality and is better supported by Oracle). In general, you should use the smallest percentage that is sufficient to produce accurate statistics. If you can, test the use of a few different percentages (and a COMPUTE), and compare the performance of SQL statements with each set of statistics.

Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close