[
https://issues.apache.org/jira/browse/IGNITE-21353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-21353:
---------------------------------------
Labels: ignite-3 (was: )
> 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
> Priority: Major
> Labels: ignite-3
>
> 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)
