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!

Reduce Extents for Indexes

Status
Not open for further replies.
schu

schu

MIS
Jun 21, 2001
188
HK
The number of extents for my indexes have grown quick large,
upto and over 100.

How do I reduce the extents for indexes, and is it possible to set the first extent and next extent size for indexes.

I am using IDS 7.31 UC

thanks
 
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
jrichemont
  • Locked
  • Question
Cursor hangs on 64 bit linux. Works for 32
Replies
0
Views
69
jrichemont
jrichemont
aft5425
  • Locked
  • Question
All of the columns in my form are not showing
Replies
0
Views
84
aft5425
aft5425
greggory
  • Locked
  • Question
Influence of number of indexes on a table
Replies
1
Views
69
mberni
mberni
Madbull
  • Locked
  • Question
autofill on indexes when inserting records
Replies
1
Views
65
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top