Ray,
By the way, which version do you use?
Evgenii
чт, 15 нояб. 2018 г. в 09:38, Evgenii Zhuravlev <e.zhuravlev...@gmail.com>:
> 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/
>>
>
