-
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?
-
You can rebuild index online with certain restrictions in enterprise edition.
-
You can partition the table and rebuild index on partition by partition so that only partition rows are locked.
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
|
|