This discussion is archived
8 Replies Latest reply: Apr 25, 2013 2:40 AM by Martin Preiss RSS

Index With Multiple Columns

user4295847 Newbie
Currently Being Moderated
If I create an index on columns (A, B, C), in that order, my understanding is that the database will be able to use it even if I search only on (A), or (A and B), or (A and B and C), but not if I search only on (B), or (C), or (B and C). Is this correct?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points