OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Analse tables (Oracle 9i ,AIx 5.2)

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

Analse tables [message #451969]

Mon, 19 April 2010 05:38

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

Report message to a moderator

Re: Analse tables [message #451970 is a reply to message #451969]

Mon, 19 April 2010 05:41

cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester

Senior Member

There's a last_analyzed column on user_indexes that'll tell you.

Report message to a moderator

Re: Analse tables [message #451974 is a reply to message #451969]

Mon, 19 April 2010 05:56

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

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

Re: Analse tables [message #452171 is a reply to message #451969]

Tue, 20 April 2010 07:57

soundar
Messages: 9
Registered: October 2009

Junior Member

thanks for your inputs

Report message to a moderator

Previous Topic:	Parsing of sql-statements
Next Topic:	Tune sql query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 07:56:08 CST 2024