Google
Information Storage and Retrieval: Unusable Indexes

Pages

Thursday, August 4, 2011

Unusable Indexes

To load data in a table efficiently, we can make Indexes as UNUSABLE. However, the TRUNCATE operation should be done before making the indexes unusable. If table is truncated after the indexes are made unusable, then it will have no effect. The TRUNCATE will automatically make the index USABLE. so the correct order to load data will be as follows:

  • truncate the table
  • set the indexes to unusable
  • load the data
  • rebuild the indexes

No comments: