Home » RDBMS Server » Performance Tuning » Estimate_Percent for Analyze Schema
Estimate_Percent for Analyze Schema [message #192348] 
Tue, 12 September 2006 00:32 
rkulasek
Messages: 15 Registered: April 2006

Junior Member 


Hi
We are running a database where the largest tables could run into a few billion rows. The rest of the tables load only thousands of rows.
We are trying to do analyze schema on this db.
Is there any recommended estimate_percent we can use for analyzing schema?
Does it make sense to use individual estimate_percent numbers for each table? If so, how do we determine what estimate_percent to use for which table?
Your inputs will be very useful
Thanks much
Raja




Re: Estimate_Percent for Analyze Schema [message #192417 is a reply to message #192348] 
Tue, 12 September 2006 04:56 
rkulasek
Messages: 15 Registered: April 2006

Junior Member 


Hi Mahesh
The tables are non partitioned.
By the way, could you explain how to use "analyze table with estimate percent" for these tables?
How do I determine what estimate_percent to use for which table?
If you can provide links to the documentation also, it would help
Thanks much
Raja




Re: Estimate_Percent for Analyze Schema [message #192867 is a reply to message #192348] 
Thu, 14 September 2006 00:25 
rkulasek
Messages: 15 Registered: April 2006

Junior Member 


Thanks very much for your information Mahesh.
My next question is  is it possible to determine what estimate_percent to use with what tables when gathering table stats?
For example,
For the biggest table, use x%
For the least populated table, use y%
etc.
Your inputs are much appreciated
Thanks
Raja



Goto Forum:
Current Time: Wed Oct 26 22:21:44 CDT 2016
Total time taken to generate the page: 0.13529 seconds
