Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    35

    Unanswered: Do i need to build index after truncate

    Hi All,

    I have a script which truncates tables everyday then i have a process which load the tables using sqlldr.

    Some of the tables has index.

    Does the index need to be rebuild after truncate and reloading ?

    Is the performance affected?


    Thanks.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Anytime you delete from a table, the rows in the underlying indexes are "marked" for delete. They do NOT release their space. This is causing index "browning". The physical number of rows in the index is growing... You should rebuild indexes

    HTH
    Gregg

  3. #3
    Join Date
    Jul 2003
    Location
    Kansas, USA
    Posts
    12
    Also, depending on the size of the load(s), it may save time to drop the index or indexes prior to the start of the load, and then create them afterwards, so the indexes aren't being updated during the load process.
    Adam vonNieda
    http://www.oracletool.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
  •