Grant Holman
New Member
Hypothetical:
Table X has 4 char fields A,B,C and D.
I need to index on A + B + C and A + B + D. What are the appropriate indexes to create for the table:
Choice 1:
Index 1 A + B
Index 2 C
Index 3 D
Choice 2:
Index 1 A + B + C
Index 2 A + B + D
I'm thinking Choice 1 as Progress will bracket on multiple indexes. Maybe both are wrong! Let me know your thoughts.
Table X has 4 char fields A,B,C and D.
I need to index on A + B + C and A + B + D. What are the appropriate indexes to create for the table:
Choice 1:
Index 1 A + B
Index 2 C
Index 3 D
Choice 2:
Index 1 A + B + C
Index 2 A + B + D
I'm thinking Choice 1 as Progress will bracket on multiple indexes. Maybe both are wrong! Let me know your thoughts.