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

Thread: Index fragmentation in LMT

  1. #1
    Join Date
    Oct 2001
    Location
    India
    Posts
    36

    Index fragmentation in LMT

    Hi All,
    In our database all the index and data tablespaces are LMT tablespaces. We are aware that the LMT tablespaces doesnt have fragmentation. But I have read some article, stating that the index objects will have holes while there are frequent deletions in data, and hence they are fragmented and the only way to correct them is to rebuild the indexes. Even the indexes are in the LMT this will happen.

    So just correct me whether my understanding is correct or not.

    As my indexes are in LMT, so if I rebuild them, will there be any use out of that?

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Please don't raise duplicate threads...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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