Home » RDBMS Server » Performance Tuning » Index rebuild issue (oracle 9i,linux)
Index rebuild issue [message #303181] Thu, 28 February 2008 04:36 Go to next message
tannad
Messages: 43
Registered: January 2008
Location: mumbai
Member
Hi all;
My database is OLTP having thousands of tables
there are so many indexes on the table
For tuning issue
How I find that which specific indexes have to rebuilt or coalesces?

Thanks in Advance
Tannad
Re: Index rebuild issue [message #303185 is a reply to message #303181] Thu, 28 February 2008 04:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>For tuning issue
How did you decide that the indexes where the problem and rebuilding them will fix it?
Re: Index rebuild issue [message #303187 is a reply to message #303181] Thu, 28 February 2008 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How I find that which specific indexes have to rebuilt or coalesces?

I give the answer: none of them.

Regards
Michel
Re: Index rebuild issue [message #303188 is a reply to message #303185] Thu, 28 February 2008 04:47 Go to previous messageGo to next message
tannad
Messages: 43
Registered: January 2008
Location: mumbai
Member
No
I want just the information that
at what time we have to rebuilt the index and which index should be rebuild?

thanks for reply
Re: Index rebuild issue [message #303203 is a reply to message #303188] Thu, 28 February 2008 06:23 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the answer is never (at 99.999%).

Regards
Michel
Previous Topic: Query performance
Next Topic: trace-strange case
Goto Forum:
  


Current Time: Sat Dec 03 16:10:23 CST 2016

Total time taken to generate the page: 0.10307 seconds