[jira] [Created] (IGNITE-8384) SQL: Secondary indexes should sort entries by links rather than keys

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (IGNITE-8384) SQL: Secondary indexes should sort entries by links rather than keys

Anton Vinogradov (Jira)
Vladimir Ozerov created IGNITE-8384:
---------------------------------------

             Summary: SQL: Secondary indexes should sort entries by links rather than keys
                 Key: IGNITE-8384
                 URL: https://issues.apache.org/jira/browse/IGNITE-8384
             Project: Ignite
          Issue Type: Task
          Components: sql
    Affects Versions: 2.4
            Reporter: Vladimir Ozerov
             Fix For: 2.6


Currently we sort entries in secondary indexes as {{(idx_cols, KEY)}}. The key itself is not stored in the index in general case. It means that we need to perform a lookup to data page to find correct insertion point for index entry.

This could be fixed easily by sorting entries a bit differently - {{idx_cols, link}}. This is all we need.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)