Yury Gerzhedovich created IGNITE-21353:
------------------------------------------
Summary: Sql. Support for choosing the primary key index type.
Key: IGNITE-21353
URL: https://issues.apache.org/jira/browse/IGNITE-21353
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Yury Gerzhedovich
As of now we support choosing type just for secondary indexes, like a
_CREATE INDEX idx_name ON table *USING TREE* (column_name)_
But for PK we always create under the hood HASH index.
Let's introduce ability to choose type for PK by the analogy with a secondary
indexes;
it should be add an optional parameter *USING type* for PRIMARY KEY definition
CREATE TABLE ..... PRIMARY KEY *[ USING BTREE | HASH ]* (column1, column2, ...
column_n)...
Also let's set BTREE as default for PK without set concrete type.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
