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 derfloh 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
Joined
Oct 25, 2002
Messages
6
Location
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 Question
onstat -g ses returns "Changing data structure forced command termination"
Replies
1
Views
762
tuccero
tuccero
kray4660
  • Locked
  • Question Question
Trying to do a count on logged in users
Replies
1
Views
547
kray4660
kray4660
evgeniosc
  • Locked
  • Question Question
Copy rows as they inserted on a replica table using trigger
Replies
0
Views
445
evgeniosc
evgeniosc
aft5425
  • Locked
  • Question Question
Avoid duplicates on phn_nbr while joining a table to itself
Replies
1
Views
290
PHV
PHV
jrichemont
  • Locked
  • Question Question
Cursor hangs on 64 bit linux. Works for 32
Replies
0
Views
182
jrichemont
jrichemont

Part and Inventory Search

Sponsor

Back
Top