questions about index
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: questions about index

  1. #1
    Join Date
    Dec 2000
    Posts
    21
    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!

  2. #2
    Join Date
    Mar 2001
    Posts
    22

    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.
    hptse

  3. #3
    Join Date
    Jul 2000
    Posts
    243
    Hi linda

    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width