[dba-SQLServer] Covering Indexes

Well, I'm no expert, but I do know that the sort follows the index seeks.
The index seeks grab the data, then the sort takes place either in memory if
there's enough or in tempdb if not enough memory, so it still seems to me
that the optimizer and cost analyzer can use the index. The sort is a
subsequent process.

Arthur

On Wed, Jul 23, 2008 at 7:10 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote:

> 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?
>