>Thanks..
>I am also assuming that that order that an index in I.E. CUSTNO+PIN or
>PIN + CUSTNO effects the performance of an ORDER BY ??

Yes, it could do. But the most important thing is that an index on (Custno,
Pin) cannot be used when searching or ordering by Pin alone, whereas (Pin,
Custno) could.

Set