Re: Next Extend For Index

From: "John" <jokarma@polbox.com> > >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". According to a recent discussion on the matter, it seems that the NEXT SIZE of an index is proportional to the NEXT SIZE of the table. So if your NEXT SIZE is 1000 and your index is 1/10th of your row size, your next size for the index will be 100. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com