Next Extend For Index

I have a large table with 22,000,000 records and 10 indexes. The indexes are very large. can I change the next extent for indexes like "ALTER TABLE... MODIFY NEXT SIZE". Thanks in advance.

No. Only the table data has extents - when an extent is allocated for the table data index space is automatically increased. Are your indexes in different dbspaces than the table data? Also, what is the problem you are trying to solve - although I can guess that dealing with the index space is an issue. Tell us more about it. John wrote: > I have a large table with 22,000,000 records and 10 indexes. The indexes are > very large. can I change the next extent for indexes like "ALTER TABLE... > MODIFY NEXT SIZE". > > Thanks in advance.

John wrote: > > I have a large table with 22,000,000 records and 10 indexes. The indexes are > very large. can I change the next extent for indexes like "ALTER TABLE... > MODIFY NEXT SIZE". For attached indexes on non-fragmented tables (or even attached indexes on fragmented tables created by versions prior to V7.21, installing later versions did not automatically convert these indexes) the extent sizes are the same as the table's extent sizes as the index pages are interleaved with data pages as needed. All other indexes are really detached and for detached indexes the index's extent and next sizes are calculates as the ratio of the key length to the maximum rowsize times the extent or next size of the table. You do not have independent control over this. You can restructure the indexes extents with a different size by changing the next size of the table and dropping and then rebuilding the index. Art S. Kagel