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)

Reply via email to