查询mssql大批量数据

数据库内有500W条数据，查询的时候如何优化

---

这段时间也在看SQL.我觉得这两本书不错!SQL艺术,SQL2008技术内幕 T-SQL基础.

确实写一条高效的SQL不是容易的事!我记得最清楚的一条是:最近过滤掉不符合条件的记录

---

500W.......这个结果谁看的完.
sql语句复杂的话,建议用存储过程. 优化明确精确的数据结果进行查询.

---

select distinct jixing,guige,danwei,zhuanhuanbi,shengchanqiye,tongyongming from bi_zhongbiaobiaozhunhua as m2 where exists (select id from bi_tongyong as m1 where m1.id=m2.tongyongming and exists (select tongyongname from bi_tongyong where tongyongname=m1.tongyongname and exists(select id from bi_shengchanqiye where id=bi_tongyong.shengchanqiye and shengchanqiye like'%神威药业%')) and shengchanqiye not in (select id from bi_shengchanqiye where shengchanqiye like '%神威药业%')) order by tongyongming desc
这样的一条语句，我已经在表中建了索引

---

这样的语句如何优化?