What is ONLINE option?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is ONLINE option?
Rating:
ONLINE is an option of the ALTER INDEX REBUILD statement, which is used to minimize locking contentions that may arise at the time of rebuilding an index. Locking contentions generally arise when several operations are being simultaneously performed with the index rebuilding operation, on a table corresponding to the index.
Rating:
Was this information helpful?
Other articles
- What are latches?
- What is a cursor?
- What is shared pool?
- What is unquiesced state?
- What are Online Transaction Processing (OLTP) systems?