When should I rebuild a index? Which factors are used to determine new storage parameters? I have a table which has a B-tree index on it is rebuilded every night. After the index is rebuilded, the number of extents increased from 1 to 150 within 24 hrs. Please help me on this problem. Thanks in advance!
How to rebuild
Do you rebuild the index by droping it and re-create with sql script ?
Was the index created with a big initial extent ?
Have you specify the storage clause for the index ?
If not, it may due to the default tablespace storage clause make the initial and next extents small so that recreating the index without storage clause made more extents allocated.
please post the inddex storage parameters and you rebuilt statment so we can all help you. upfront it looks like your next ex parameter is something like 8K, or smaller.
Click Here to Expand Forum to Full Width