Home » RDBMS Server » Performance Tuning » What does analyzing a table do for the indexes ? (Oracle 11g Win 7)
What does analyzing a table do for the indexes ? [message #567329] Wed, 26 September 2012 11:46 Go to next message
jxh461
Messages: 182
Registered: March 2005
Senior Member
Hi All,

Can someone tell me what analyzing a table does to existing indexes ?
Do I need to rebuild the indexes after dbms_stats.gather_table_stats command ?

Thanks in advance

[Updated on: Wed, 26 September 2012 11:49]

Report message to a moderator

Re: What does analyzing a table do for the indexes ? [message #567337 is a reply to message #567329] Wed, 26 September 2012 15:12 Go to previous messageGo to next message
Michel Cadot
Messages: 59421
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Do I need to rebuild the indexes after dbms_stats.gather_table_stats command ?


No.

Regards
Michel
Re: What does analyzing a table do for the indexes ? [message #567504 is a reply to message #567337] Tue, 02 October 2012 16:48 Go to previous message
alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California
Senior Member
If you use "cascade=>TRUE" it will also analyse the indexes of the table.

ECSCDAP1P > execute dbms_stats.gather_table_stats('SCOTT','EMP',estimate_percent=>100,cascade=>TRUE);

PL/SQL procedure successfully completed.

"cascade=>TRUE" also works for all the indexes if you gather stats at the schema level.
ECSCDAP1P > EXEC dbms_stats.gather_schema_stats('SCOTT', cascade=>TRUE);

PL/SQL procedure successfully completed.
Previous Topic: appropriate memory
Next Topic: how to tune 100s of transactions over single table
Goto Forum:
  


Current Time: Wed Oct 22 23:08:17 CDT 2014

Total time taken to generate the page: 0.08991 seconds