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.
Managing indexesAn index on the appropriate column can save thousands, tens of thousands, or in extreme cases, even millions of disk operations during a query. However, indexes entail costs.
Indexes on columnsYou can create an index for one or more columns in a table. Indexes are required on columns that must be unique and are not specified as primary keys.

Indexes on columns

You can create an index for one or more columns in a table. Indexes are required on columns that must be unique and are not specified as primary keys.

In addition, you must add an index on columns that:

Are used in joins that are not specified as foreign keys
Are frequently used in filter expressions
Are frequently used for ordering or grouping
Do not involve duplicate keys
Are amenable to clustered indexing