Please refer to [1] and other sections of 'SQL queries' page for some information about this. Most likely, in your case you will need to create individual indexes for all field that can be used in WHERE clause. Whether or not you need group indexes, depend on subset sizings after indexes are applied and on particular queries you're going to execute. You should run tests and use EXPLAIN to check indexes are used.
[1] https://apacheignite.readme.io/docs/sql-queries#choosing-indexes -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/What-index-should-I-create-tp5068p5176.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.