You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2017/11/09 11:46:01 UTC
[jira] [Created] (IGNITE-6850) SQL: integrate index inline size to
CREATE INDEX syntax
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)