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.
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....
Previous Topic: how to measure a database performance?
Next Topic: commit takes a long time
Goto Forum:
  


Current Time: Wed Feb 21 03:01:56 CST 2024