I have an object with fields member_id, name, and priority. I have created a grouped index on member_id+ name and member_id + priority. I want to run queries like "select * from table where member_id = 123 order by member_id, priority asc. The problem is that sometimes the query optimizer chooses the wrong index for the where clause (member_id + name) and the sorting cannot take advantage of the index. Is there a way to coerce the right index to be used in the WHERE clause that matches the ORDER BY clause?
-- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/grouped-index-sort-vs-filter-tp9885.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
