You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2017/11/09 11:46:01 UTC

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

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)