Hello! Regarding index order:
Index order basically means that records in the data_idx1 index will be sorted by field1; if two records have the same field1 value, field3 will be used as sorting tier, and if both field1 and field3 are same, field2 will be used as sorting tier. Index is basically a sorted list of row ids with some bells and whistles on top. This means, you can look up data when you specify field1 (using binary search). If you don't specify field1, you can't use this index. If you use field3 also, you can look data up more precisely. Then you can also use field2. You can't use field2 without field3 and either one without field1. So in your case, a) and b) will benefit from having index data_idx1, but neither one will use fields other than field1. All other statements won't use this index at all. Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
