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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer