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, Kevin
