Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009

    Unanswered: Index creation on a huge table

    Environment Details: V9.5 FP4
    Single partition environment

    We are planning to create an index on a table which is of size 180 GB. Could anyone let us know the preventive steps to be taken for doing this inorder to get this finish faster? Anything like increasing the transaction log space ... ?

  2. #2
    Join Date
    May 2005
    You can look into using NOT LOGGED INITIALLY on the table for the session that you create the index, This will help with the performance and also it doesn't log when used.

    Be sure to read about it and test it, before implementing in Prod.

  3. #3
    Join Date
    Aug 2008
    Toronto, Canada
    larger sortheap, larger tempspace's bufferpool (in case sort spills and to minimize spilling to disk).

Posting Permissions

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