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

Thread: Height In Index

  1. 12-10-2001, 10:51 AM #1
    ybadejo
    ybadejo is offline Junior Member
    Join Date
    Jun 2001
    Posts
    24
    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?.

    Thanks.

    YB.

    smiles off
    Reply With Quote Reply With Quote
  2. 12-10-2001, 12:56 PM #2
    Sharma
    Sharma is offline Member
    Join Date
    Nov 2000
    Posts
    224
    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?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width