Partitions

Removed

Indexes are no longer partitioned. The WITH (Partitions = n) option of CREATE INDEX, CREATE UNIQUEKEY and REBUILD INDEX is still accepted, so existing scripts keep working, but it is ignored.

Indexes are now stored in RocksDB with one entry per indexed document, so lookups read only the entries for the requested values and writes don't contend for shared partition files. See Create Index.

SQL :: Alter Index

Creates and drops indexes and unique keys.

SQL :: Create Index

Creates an index or a unique key to speed up queries.

SQL :: Insert

Insert creates new documents in a schema.

SQL :: Keywords

A breakdown of all of the statements and keywords supported by the query processor.

SQL :: Rebuild Index

Rebuilds an index from the documents in its schema.

SQL :: Where

The where clause filters the documents read, updated or deleted by a statement.