查询mssql大批量数据

[sooxue]

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

[街头小贩]

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

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

[dusttosky]

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

[sooxue]

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
这样的一条语句，我已经在表中建了索引

[sooxue]

这样的语句如何优化?