Classification of Indexes

Indexes can be classified based on fields, schema, entries, or a combination of them.

Description of the illustration images_types.png

Single Field Index: An index is called a single field index if it is created on only one field of a table.

Composite Index: An index is called a composite index if it is created on more than one field of a table

Fixed Schema Index: An index is called a fixed schema index if all the fields that are indexed are strongly typed data.

Note:

A data type is called precise if it is not one of the wild card types. Items that have precise types are said to be strongly typed.

Schema-less Index (JSON Index): An index is called a JSON index if at least one of the fields is JSON data or fields inside JSON data.

Simple Index: An index is called a simple index if for each row of data in the table, there is one entry created in the index.

Multikey Index: An index is called a multikey index if for each row of data in the table, there are multiple entries created in the index.

You can create indexes on the values of one or more SQL built-in functions.

List of functions that can be indexed:

The following subset of the Built-in functions can be indexed.

Functions on Timestamps:

• year
• month
• day
• hour
• minute
• second
• millisecond
• microsecond
• nanosecond
• week

Functions on Strings:

• length
• replace
• reverse
• substring
• trim
• ltrim
• rtrim
• lower
• upper

Functions on Rows:

• modification_time
• expiration_time
• expiration_time_millis
• row_storage_size

See Built-in functions for more details on what a built-in function is and how to use these functions.