sql查詢語句優化解决方案

sql查詢語句優化

SQL code

 select distinct a.EmpID,a.EmpName from dbo.HFCM_File_D a,vw_account_Users_All b  where a.empid=b.empid  and a.FileFlag='N'  and  (b.Area ='01' or b.Area ='02')  and  a.FileTypeID='F01001' and Convert(NVarchar(10),b.DateIn,111) BETWEEN '2012/02/01' AND  '2012/02/03'  order by a.EmpID