Home » RDBMS Server » Performance Tuning » REBUILD INDEXES
REBUILD INDEXES [message #65170] Mon, 31 May 2004 01:17 Go to next message
MUHAMMAD SAFHAN GHAURI
Messages: 6
Registered: November 2000
Junior Member
HI,
I want to rebuild indexes. Please provide me script for perform this operation.

Thanks.
MUHAMMAD SAFHAN GHAURI.

Report message to a moderator

Re: REBUILD INDEXES [message #65171 is a reply to message #65170] Mon, 31 May 2004 04:35 Go to previous message
ora9iDBA
Messages: 31
Registered: March 2003
Member
alter index indexname rebuild ;

But why u want to rebuild the index ?
better way is to coalesce the index....

Report message to a moderator

Previous Topic: how to measure a database performance?
Next Topic: commit takes a long time
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 00:02:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.