ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kirill Shirokov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-6850) SQL: integrate index inline size to CREATE INDEX syntax
Date Tue, 14 Nov 2017 09:30:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-6850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16251136#comment-16251136
] 

Kirill Shirokov commented on IGNITE-6850:
-----------------------------------------

Fixed all the items mentioned by [~skalashnikov]. Testing did not reveal any regression.

> 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