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

extents on indexes

Status
Not open for further replies.
sazzct

sazzct

IS-IT--Management
Oct 25, 2002
6
US
I seem to have got my number of extents down, but how do you reduce the number of extents on your indexes? or am I just doing something wrong?
 
Sort by date Sort by votes
If you drop and then recreate an index it should consolidate the extents as long as you have contiguous free space.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tuccero
  • Locked
  • Question
onstat -g ses returns "Changing data structure forced command termination"
Replies
1
Views
285
tuccero
tuccero
kray4660
  • Locked
  • Question
Trying to do a count on logged in users
Replies
1
Views
217
kray4660
kray4660
evgeniosc
  • Locked
  • Question
Copy rows as they inserted on a replica table using trigger
Replies
0
Views
151
evgeniosc
evgeniosc
aft5425
  • Locked
  • Question
Avoid duplicates on phn_nbr while joining a table to itself
Replies
1
Views
117
PHV
PHV
jrichemont
  • Locked
  • Question
Cursor hangs on 64 bit linux. Works for 32
Replies
0
Views
70
jrichemont
jrichemont

Part and Inventory Search

Sponsor

Back
Top