ignite-issues mailing list archives

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

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

Vladimir Ozerov commented on IGNITE-6850:

[~kirill.shirokov], we need to add unit tests for new feature to {{SqlParserCreateIndexSelfTest}}.
The rest looks good to me.

> 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

View raw message