In any case, answer for replacing '?' with variables also placed on the
same page I've shared earlier.
Evgenii
чт, 15 нояб. 2018 г. в 08:25, Ray <ray...@cisco.com>:
> 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/
>
