Re: Index not getting applied

2019-03-06 Thread ashishb888
You can make good use of Index Hints. e.g. SELECT * FROM Person USE INDEX(index_age) WHERE salary > 15 AND age < 35; -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Index not getting applied

2019-03-06 Thread mausam
Hi, I am using Ignite Cache with Persistence. While execution over large tables, i noticed the below message repeatedly getting logged. [WARNING][query-#100%IGNITE%][IgniteH2Indexing] Query execution is too long [time=4863 ms, sql='SELECT PUBLIC.__Z0._KEY __C0_0, PUBLIC.__Z0._VAL __C0_1 FROM PUBL