Create and View Indexes
An index is a database structure that enables you to retrieve data from database tables efficiently. Indexes provide fast access to the rows of a table when the key(s) you are searching for is contained in the index.
An index is an ordered map in which each row of the data is called an
entry. An index can be created on atomic data types, arrays, maps, JSON, and GeoJSON
data.. An index can store the following special values:
- NULL
- EMPTY
- json null (It is applicable only for JSON indexes)
If you want to follow along with the examples, see Sample data to run queries to view a sample data and use the scripts to load sample data for testing. The scripts create the tables used in the examples and load data into the tables.