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

Thread: rebuild index

  1. #1
    Join Date
    Apr 2001
    Posts
    151
    Hi all,

    How to see if my index are fragmented? If I want to rebuild index, anything I should be aware of? (performace would be bad, so I won't run rebuild script during peak time)

    oralce 8.0.5.2.1 on NT4.0
    Index size about 15G

    Thank you
    Elin@trend

  2. #2
    Join Date
    Jun 2001
    Posts
    2
    hi,
    use rebuild online option

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    If u want to see if ur indexes are fragmented ,please run the following command and view the INDEX_STATS table to get the statistics in the same session.

    sql>analyze index validate structure;
    Index analyzed

    sql>select name,(del_lf_rows/lf_rows)*100 "Percentage" from index_stats

    If the percentage is equal or greater than 20% rebuild the index.Also rebuild the index at off-peak hours usually in the night.

    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards.
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com


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