You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Taras Ledkov (Jira)" <ji...@apache.org> on 2021/06/18 09:22:00 UTC

[jira] [Created] (IGNITE-14936) Benchmark sorted index scan vs table's partitions scan

Taras Ledkov created IGNITE-14936:
-------------------------------------

             Summary: Benchmark sorted index scan vs table's partitions scan
                 Key: IGNITE-14936
                 URL: https://issues.apache.org/jira/browse/IGNITE-14936
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Taras Ledkov
             Fix For: 3.0.0-alpha3


We have to decide what are data structures is used for PK and table scan.
Possible cases:
- table partitions sorted by plain bytes/hash (in fact: unsorted);
- table partitions sorted by PK columns;
- PK sorted index (one store for all partitions on the node).

All cases have pros and cons. The choice should be based on benchmarks.






--
This message was sent by Atlassian Jira
(v8.3.4#803005)