|< < 25 > >|

Multi-column index keys

Indexes handle multi-column keys easily.

Suppose index key is on three field: A, B, C

What searches can be supported?

A = 2 and B = 7 and C = 3

  • Yes, whether the index is hash-based or tree-based.

    • |< < 25 > >|