When you cannot create or drop indexes online

You cannot use the CREATE INDEX ONLINE and the DROP INDEX ONLINE statements under certain circumstances.

You cannot use the CREATE INDEX ONLINE statement:

  • To create an index at the same time that a table is being altered
  • To create a clustered index
  • To create a Virtual-Index Interface (VII) /R-tree index
  • To create a functional index
  • To create an index that is partitioned by an interval fragmentation strategy
  • To create an index on a table that is partitioned by an interval fragmentation strategy
You cannot use the DROP INDEX ONLINE statement:
  • To drop a Virtual-Index Interface (VII) /R-tree index
  • To drop a clustered index

Copyright© 2019 HCL Technologies Limited