Height In Index
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Height In Index

  1. #1
    Join Date
    Jun 2001
    Hi all,
    I have an index whose height level is high every week and I have rebuilt twice and the del count is 0 I plan to rebuild again.
    Any thought on what this or permanent solution?.



    smiles off

  2. #2
    Join Date
    Nov 2000
    Looks like your table has lot of Delete issued against it, and it makes height to grow as the new inserts span new blocks.

    Do you really need index on this table?

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