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

sql查要24秒

大家忙香香法油油啊!!

[解决办法]
1. 不使用distinct，改用Group By
2. 将搜索的字段加上索引
[解决办法]

探讨

jjkk168
改成broup by我改了理上速度快的,但是快,加索引就不加了,索引我由於某原因加不了.

[解决办法]
索引。