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

SQL: integrate index inline size to CREATE INDEX syntax

    XMLWordPrintableJSON

Details

    • Task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.4
    • sql
    • 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

          causes

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-10602 Failure parsing INLINE_SIZE if CREATE INDEX is one of multiple statements

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is related to

          Task - A task that needs to be done. IGNITE-6948 SQL: Document new INLINE_SIZE option in CREATE INDEX command

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #3013

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: