Results 1 to 3 of 3

Thread: Rebuilding the index

  1. 05-20-2010, 10:54 PM #1
    brij.dba
    brij.dba is offline Registered User
    Join Date
    May 2010
    Posts
    1

    Rebuilding the index

    While rebuilding the index, does rebuilding of index locks the database ? If yes, how can we prevent locking of database while rebuilding the index?
    Reply With Quote Reply With Quote
  2. 05-21-2010, 08:08 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can rebuild index online with certain restrictions in enterprise edition.
    Reply With Quote Reply With Quote
  3. 05-21-2010, 08:16 AM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can partition the table and rebuild index on partition by partition so that only partition rows are locked.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules