Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

reorg index vs rebuild index

Status
Not open for further replies.
MrJRW

MrJRW

IS-IT--Management
Feb 6, 2002
47
US
Good Afternoon

What are the advantages/disadvantages of using REBUILD INDEX vs. REORG INDEX ??
 
Sort by date Sort by votes
Rebuild: throw it away and build a new one
Reorg: reorganize the existing one.
Depending on the amount of changes you have the one or the other might be more useful.
 
Upvote 0 Downvote
If the index is corrupted you have to REBUILD it (to get the correct keys from the table)
If the index 'just' need to be cleaned up, you can use REORG INDEX.
If you choose REORG you can still use the table (without the index) while the REBUILD utility also uses the table.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

YuriyS.
  • Locked
  • Question
Index based on other existing index? 1
Replies
1
Views
115
johnherman
johnherman
cpu533
  • Locked
  • Question
table reorg request
Replies
2
Views
89
cpu533
cpu533
JMaria
  • Locked
  • Question
Calculation of Reorg times in DB2
Replies
1
Views
120
papadba
papadba
TSch
  • Locked
  • Question
Reorg Tablespace Command
Replies
1
Views
91
JackVam
JackVam
jdu2006
  • Locked
  • Question
WHY is LogicalFile but not index?
Replies
0
Views
54
jdu2006
jdu2006

Part and Inventory Search

Sponsor

Back
Top