Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Performance GuideThe HCL OneDB™ Performance Guide describes how to configure and operate your HCL OneDB™ database server to improve overall system throughput and to improve the performance of SQL queries.
Indexes and index performance considerationsHCL OneDB™ provides several types of indexes. Some performance issues are associated with indexes.
Creating and dropping an index in an online environmentYou can use the CREATE INDEX ONLINE and DROP INDEX ONLINE statements to create and drop an index in an online environment, when the database and its associated tables are continuously available.
When you cannot create or drop indexes onlineYou cannot use the CREATE INDEX ONLINE and the DROP INDEX ONLINE statements under certain circumstances.

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

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.