IndexKind Class

The index entries are hashed to serve point look up queries. Can be used to serve queries like: SELECT * FROM docs d WHERE d.prop = 5

Hash: Literal['Hash'] = 'Hash'

MultiHash

MultiHash: Literal['MultiHash'] = 'MultiHash'

The index entries are ordered. Range indexes are optimized for inequality predicate queries with efficient range scans. Can be used to serve queries like: SELECT * FROM docs d WHERE d.prop > 5

Range: Literal['Range'] = 'Range'