ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vladimir Ozerov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-6850) SQL: integrate index inline size to CREATE INDEX syntax
Date Thu, 09 Nov 2017 11:46:01 GMT
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)

Mime
View raw message