Analse tables [message #451969] |
Mon, 19 April 2010 05:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
soundar
Messages: 9 Registered: October 2009
|
Junior Member |
|
|
Hi,
When i analyze the table with below command, the table is getting analyzed. I want to know the corresponding index also got analyzed or not?
DBMS_STATS.gather_table_stats ('XXQP', 'XXQP_SAMPLE', estimate_percent => 30);
Thanks
|
|
|
|
Re: Analse tables [message #451974 is a reply to message #451969] |
Mon, 19 April 2010 05:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
And maybe reading the documentation will give you the default behaviour?
And maybe putting the parameter that ensures that your indexes are also analyzed will prevent you from asking this question.
Regards
Michel
[Updated on: Mon, 19 April 2010 05:57] Report message to a moderator
|
|
|
|