SQL数据库索引查询

SELECT  IA_ID,IA_Title,IT_ParentID,IA_Content,IA_CreateDate,IA_Author,
'http://'+ia.IA_CityCode+'.edushi.com/bang/info/'+it.IT_ParentPath+'-'+CAST(ia.IT_ID AS VARCHAR(10))+'-n'+CAST(ia.IA_ID as varchar(10))+'.html'  AS WebSite,0 AS States
 FROM dbo.InfoArticle ia WITH (NOLOCK,INDEX=IX_CreateDate)
LEFT JOIN dbo.InfoType it WITH (NOLOCK) 
ON ia.IT_ID = it.IT_ID  WHERE 1=1  AND ia.IA_CreateDate BETWEEN '2016-06-01 00:00:00' AND '2016-06-06 00:00:00'