Home » SQL & PL/SQL » SQL & PL/SQL » Partition index analyze
Partition index analyze [message #259412] Wed, 15 August 2007 10:05 Go to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

I need to analyze the table which contains indexes.
if i analyze the table it will analyze the indexes too. or i need to do it seprate..

Thanks in advance

[Updated on: Wed, 15 August 2007 10:29]

Report message to a moderator

Re: Partition index analyze [message #259415 is a reply to message #259412] Wed, 15 August 2007 10:10 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>I need to analyze the index which is partitioned.
I need to go to the office today.
>Is it necessary,
Not for me.
>i need to analyze the index per partition.
Congratulations. Please proceed.
Re: Partition index analyze [message #259421 is a reply to message #259415] Wed, 15 August 2007 10:20 Go to previous messageGo to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

anacedent..

You have a great sence of humour. I like that, let's go to funny.com forum . It seems like here we need some serious peoples. But there we can have all kind of peoples.
Re: Partition index analyze [message #259442 is a reply to message #259412] Wed, 15 August 2007 11:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at "cascade" parameter of gather_table_stats procedure.

Regards
Michel
Re: Partition index analyze [message #259511 is a reply to message #259442] Wed, 15 August 2007 15:17 Go to previous message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

Thanks alot. it helps ..
Previous Topic: DML Error logging
Next Topic: SELECT dates into Different Columns - A better way?
Goto Forum:
  


Current Time: Sat Dec 03 01:14:31 CST 2016

Total time taken to generate the page: 0.19202 seconds