[jira] [Created] (IGNITE-6850) SQL: integrate index inline size to CREATE INDEX syntax

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (IGNITE-6850) SQL: integrate index inline size to CREATE INDEX syntax

Anton Vinogradov (Jira)
Vladimir Ozerov created IGNITE-6850:
---------------------------------------

             Summary: SQL: integrate index inline size to CREATE INDEX syntax
                 Key: IGNITE-6850
                 URL: https://issues.apache.org/jira/browse/IGNITE-6850
             Project: Ignite
          Issue Type: Task
      Security Level: Public (Viewable by anyone)
          Components: sql
            Reporter: Vladimir Ozerov
            Assignee: Kirill Shirokov
             Fix For: 2.4


Index value inline is important optimization which used to minimize amount of data page reads when doing index lookup (see {{InlineIndexHelper}}). Currently the only way to set it is {{QueryIndex.inlineSize}} property, so it cannot be set from SQL command. We need to integrate it to our SQL syntax (see {{SqlCreateIndexCommand}}) and make sure it is propagated properly.

Sample syntax:
{code}
CREATE INDEX idx ON tbl(field) INLINE_SIZE 20;
{code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)