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

Report message to a moderator

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: 10708
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?

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
And the answer is never (at 99.999%).

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 01:53:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.