Overview
Oxla allows creating a single index on an empty table (before any row is added to the table). This index is used to sort data on storage, ordering it using indexed columns. This greatly speeds up the scanning table, reducing the scan just to the relevant portion of data.Syntax
While creating an index one should define the index name, the table for which the index is created, list of columns for which the index was created.Using index
The index is used when a query uses a range of values from a given index. To do that user must compare the index column with the literal.Performance impact
Single column index
Let’s consider the given table:commit_date
is equal to 2019-11-05.
Unfortunately, expressions like the one shown below will not take advantage of the index.