[dba-SQLServer] Covering Indexes

Assume  Three Columns 

1  2  3
A  A  A
A  A  B
A  B  A

An index sorted on columns 1,2,3 says that  AAB (row2) follows AAA

A sort on columns 1,3,2 says requires that ABA (row 3) follows AAA - how can it use the 
index? 



On 23 Jul 2008 at 14:32, Arthur Fuller wrote:

> one instance of each column mentioned. Another way to ask the question is,
> does column order in an index matter? Won't the cost analyzer figure out
> that it can make use of the index anyway?
>