ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zhengqingzheng <zhengqingzh...@huawei.com>
Subject Ignite Sql query problem using IN clause
Date Thu, 04 Aug 2016 08:19:16 GMT
Hi there,
When we using ignite sql query, we find that IN clause cannot use indexing when adding extra
'and xxx' clause.
Here are the descriptions :
If using 'IN' clause like this, and set col1 to be indexed. It works fine.
select * from table1 where col1 in (?,?,?);
However, if you add more 'and' clause like this:
select * from table1 where col1 in (?,?,?) and col2=?;
it will scan the table without going into indexing search.

Any suggestions?

Best regards,

View raw message