OraFAQ Forum: Performance Tuning » What does analyzing a table do for the indexes ?

Home » RDBMS Server » Performance Tuning » What does analyzing a table do for the indexes ? (Oracle 11g Win 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What does analyzing a table do for the indexes ? [message #567329]

Wed, 26 September 2012 11:46

jxh461
Messages: 185
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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Do I need to rebuild the indexes after dbms_stats.gather_table_stats command ?

No.

Regards
Michel

Report message to a moderator

Re: What does analyzing a table do for the indexes ? [message #567504 is a reply to message #567337]

Tue, 02 October 2012 16:48

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.

Report message to a moderator

Previous Topic:	appropriate memory
Next Topic:	how to tune 100s of transactions over single table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 16:51:34 CST 2024