Home Forums SQL Server 2005 SQL Server 2005 General Discussion cluster index or non cluster index RE: cluster index or non cluster index
tony.turner
Right there with Babe
Points: 783
More actions
May 13, 2010 at 6:57 am
#1166824
GilaMonster (5/13/2010)If, however there is an ORDER BY, and SQL can use an index to retrieve the data ordered, it avoids a sort operation.
GilaMonster (5/13/2010)
As I understand the section in BOL, this is no longer necessarily true