Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-6850

SQL: integrate index inline size to CREATE INDEX syntax

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.4
    • Component/s: sql
    • Labels:
      None

      Description

      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:

      CREATE INDEX idx ON tbl(field) INLINE_SIZE 20;
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kirill.shirokov Kirill Shirokov
                Reporter:
                vozerov Vladimir Ozerov
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: