When a column is used in more than one type of query, you might want to assign more than one column index type.
Index to Add |
||||||
Existing Index |
HG |
HNG |
LF |
CMPª |
WD |
DATE, TIME, or DTTM |
HG |
- |
1 |
2 |
1 |
1 |
1 |
HNG |
1 |
- |
1 |
1 |
2 |
2 |
LF |
2 |
1 |
- |
1 |
2 |
1 |
1 = Combination recommended. 2 = Combination not recommended. a. A CMP index applies to a pair of columns. Each of those columns always has at least one other index. |