盡量先過(guò)濾數(shù)據(jù)再進(jìn)行表連接，

例如：select a from tblUser inner join tblShop on tblUser.id=tblShop.id

　　　　　　　　　　　　　　inner join tblThing on tblUser.id=tblThing.id

　　 where tblUser.id=4

?

改為 select a

　　 from (select * from tbluser where tbluser.id=4) as tblUser

????? inner join tblShop on tblUser.id=tblShop.id

　　inner join tblThing on tblUser.id=tblThing.id

?

?

?

MSDN: http://172.18.14.131/LockSmith/Default.aspx

Great site

查詢(xún)優(yōu)化