OraFAQ Forum: Performance Tuning » Index rebuild issue

Home » RDBMS Server » Performance Tuning » Index rebuild issue (oracle 9i,linux)

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

Index rebuild issue [message #303181]

Thu, 28 February 2008 04:36

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

Mahesh Rajendran
Messages: 10707
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

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Index rebuild issue [message #303188 is a reply to message #303185]

Thu, 28 February 2008 04:47

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

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 09:59:09 CDT 2024