You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2017/11/10 12:46:00 UTC
[jira] [Commented] (IGNITE-6850) SQL: integrate index inline size
to CREATE INDEX syntax
[ https://issues.apache.org/jira/browse/IGNITE-6850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16247428#comment-16247428 ]
ASF GitHub Bot commented on IGNITE-6850:
----------------------------------------
GitHub user gg-shq opened a pull request:
https://github.com/apache/ignite/pull/3013
IGNITE-6850 SQL: integrate index inline size to CREATE INDEX syntax
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gridgain/apache-ignite IGNITE-6850
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/ignite/pull/3013.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #3013
----
commit be1d297b145322a3d9a90d49e1817a27fc56be24
Author: gg-shq <ks...@gmail.com>
Date: 2017-11-10T11:16:25Z
IGNITE-6850: Added INLINE_SIZE option to internal SQL CREATE INDEX statement
commit 8f4b677a69036aad486249c507166e5189eca979
Author: gg-shq <ks...@gmail.com>
Date: 2017-11-10T11:21:46Z
Merge branch 'master' into IGNITE-6850
commit b0e91486d98d4ae56498f11098a4b57f83e9a69a
Author: gg-shq <ks...@gmail.com>
Date: 2017-11-10T11:23:01Z
IGNITE-8650: Resolved merge conflicts in SqlCreateIndexCommand.java
----
> 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)