Oct 30, 2002 #1 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?
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?
May 1, 2003 #2 JSerman Technical User Joined Oct 29, 2002 Messages 2 Location US If you drop and then recreate an index it should consolidate the extents as long as you have contiguous free space. Upvote 0 Downvote
If you drop and then recreate an index it should consolidate the extents as long as you have contiguous free space.