Generate Statistics [message #50664] |
Fri, 29 March 2002 23:21 |
nadella srikanth
Messages: 6 Registered: March 2002
|
Junior Member |
|
|
Hi,
I would like to know how to generate statistics for the CBO? Is it only using the 'analyze'statement or r there any other ways through which we can generate statistics for the CBO?
|
|
|
|
Re: Generate Statistics [message #50716 is a reply to message #50664] |
Wed, 03 April 2002 05:36 |
Sanjay Bajracharya
Messages: 279 Registered: October 2001 Location: Florida
|
Senior Member |
|
|
analyze table xx compute statistics;
(analyzes FULL table, may take a long time)
analyze table xx estimate statistics;
(does an default of 1064 rows)
or
analyze table xx estimate statistics sample 10 percent;
analyze table xx estimate statistics sample 10000 rows;
(or whatever number you wish)
NOTE:
1. If you are sampling more than 50% of data, it will do a FULL analyze.
2. When you analyze a table, it analyzed indexes also.
|
|
|