SQL Server query optimization doesn't work like it did in VFP. This article may help http://www.simple-talk.com/sql/sql-training/the-sql-server-query-optimizer/

You can also so a web search for "SQL Server optimization"

>Hi all !
>in MySQL table index key which one is the right way ?
>key (branch)
>key (reference)
>key (date)
>select * from transaction where branch=?m.branch and reference=?m.ref and date=?m.date order by branch,reference,date
>or
>key (branch,reference,date)
>select * from transaction where branch=?m.branch and reference=?m.ref and date=?m.date order by branch