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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is difference between rebuilding an index and shrinking an index

Status
Not open for further replies.
jlaw10

jlaw10

Technical User
Jul 28, 2005
54
US
What is primary difference in results from the following commands?

ALTER INDEX <INDEX_NAME> SHRINK SPACE;

ALTER INDEX index_name REBUILD;

ALTER INDEX index_name COALESCE;


 
Status
Not open for further replies.

Similar threads

annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
283
carp
carp
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
640
carp
carp
kernal
  • Locked
  • Question
If Day of the Week='Y' (i.e. Mon='Y') and between a Start Date and End Date then Count #of Days 1
Replies
1
Views
158
Beilstwh
Beilstwh
kernal
  • Locked
  • Question
Extract after and between spaces in a string 1
Replies
1
Views
116
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top