Home » RDBMS Server » Performance Tuning » Analse tables (Oracle 9i ,AIx 5.2)
Analse tables [message #451969] Mon, 19 April 2010 05:38 Go to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 13923
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
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

Re: Analse tables [message #452171 is a reply to message #451969] Tue, 20 April 2010 07:57 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 00:59:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.