SelectIndex
Constructor
Examples:
Index on 3 columns: A, B, C.
| Query |
Constructor arguments |
Comments |
| A = 1 and B = 2 and C = 3 |
(EQ, [1, 2, 3]) |
|
| A = 1 and B = 2 |
(EQ, [1, 2]) |
C is unrestricted |
| A < 10 |
(LT, [10]) |
|
| A = 1 and B = 2 and C >= 10 |
(GE, [1, 2, 10]) |
Equality for A and B is implied. GE applies to C |
| A = 1 and B = 2 and 5 <= C <= 20 |
(GE, [1, 2, 5], LE, [1, 2, 20) |
Equality for A and B is implied. |
|