oracle 繁忙時候建立索引

        You can create and rebuild indexes online. This enables you to update base tables at the same time you are building or rebuilding indexes on that table. You can perform. DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.

        我們知道，oracle在建立索引的時候，要為索引分配空間和索引資料，我們不加online的時候就會有DML，DDL鎖，但是加了online,則DML鎖沒有了，只有DDL鎖。這樣就不會阻塞其它的使用者的操作，順利達到你建立索引的目的。