Create index
CREATE [ UNIQUE ] INDEX index
ON table [ USING TREE | HASH | RTREE | BITSET ] (column, ...)
[ WITH (options...) ]
For the sharded tables the unique index can be created only on the sharding columns. For global tables there are no restrictions.
Options can be found in tarantool documentation.
CREATE [ UNIQUE ] INDEX index
ON table USING TREE (column, ...)
[ WITH (hint = true,
[
bloom_fpr = 0.05,
page_size = 8192,
range_size = 1073741824,
run_count_per_level = 2,
run_size_ratio = 3.5
]
) ]
CREATE [ UNIQUE ] INDEX index
ON table USING RTREE (column, ...)
[ WITH (dimension = 2, distance = euclid | manhattan) ]
Depends on:
Edited by Denis Smirnov