Hello Evgenii,
I have a question about IN clause not using indexes.
>From my local test results, it seems IN clause does use indexes.
I have a table named aaa and this table has an index on field d.
The query plan indicates that IN clause does use indexes.
0: jdbc:ignite:thin://127.0.0.1/> explain select * from aaa where d in
('1','2','3');
PLAN SELECT
__Z0.A AS __C0_0,
__Z0.B AS __C0_1,
__Z0.D AS __C0_2,
__Z0.E AS __C0_3
FROM PUBLIC.AAA __Z0
/* PUBLIC."aaa_d_asc_idx": D IN('1', '2', '3') */
WHERE __Z0.D IN('1', '2', '3')
PLAN SELECT
__C0_0 AS A,
__C0_1 AS B,
__C0_2 AS D,
__C0_3 AS E
FROM PUBLIC.__T0
/* PUBLIC."merge_scan" */
2 rows selected (0.022 seconds)
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
