[jira] [Created] (IGNITE-7027) Single primary index instead of mulitple per-partition indexes

["Vladimir Ozerov (JIRA)" <ji...@apache.org>]

Vladimir Ozerov created IGNITE-7027:
---------------------------------------

             Summary: Single primary index instead of mulitple per-partition indexes
                 Key: IGNITE-7027
                 URL: https://issues.apache.org/jira/browse/IGNITE-7027
             Project: Ignite
          Issue Type: Task
          Components: cache
            Reporter: Vladimir Ozerov


Currently we have per-partition primary index. This gives us easy and effective rebalance/recovery capabilities and efficient lookup in key-value mode. 

However, this doesn't work well for SQL case. We cannot use this index for range scans. Neither we can use it for PK lookups (it is possible to implement, but will be less then optimal due to necessity to build the whole key object).

The following change is suggested as optional storage mode:
1) Single index data structure for all partitions
2) Only single key type is allowed (i.e. no mess in the cache and no cache groups)
3) Additional SQL PK index will not be needed in this case



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)