| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
