Home » RDBMS Server » Server Administration » Re-creating Indexes and Query Performance
Re-creating Indexes and Query Performance [message #53678] Fri, 04 October 2002 11:59 Go to next message
Tracy
Messages: 43
Registered: January 2000
Member
Will dropping and re-creating an index possibly improve query performance against a table?

thanks,
Tracy

Report message to a moderator

Re: Re-creating Indexes and Query Performance [message #53679 is a reply to message #53678] Fri, 04 October 2002 12:18 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
idea is to update the index TO THE LATEST.
with 8i and above, you can just rebuild the index online.
and it will definately increase the peformance of select queries, to some extent.

[Updated on: Sat, 14 March 2009 19:31]

Report message to a moderator

Previous Topic: Locks on v$global_transaction
Next Topic: Is oracle for linux free?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 14 15:32:11 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.