Hello,

Ignite adds the cache key and optionally the affinity key (if defined) as two 
last columns of all user-defined indexes (line 301 in H2TableDescriptor). For 
example, given a user index salary_idx including a single field "salary", the 
actual index is going to look like this:

CREATE INDEX "SALARY_IDX" ON "mycache"."PERSON" ("SALARY" ASC, "_KEY" ASC)

I'm wondering what is the purpose of doing so. Could someone knowledgeable 
(Vladimir O., for example) share their insights?

Thanks
Andrey

Reply via email to