Oracle 200多万条数据 查询优化
mc_dv 2015-03-26 07:51:41 一个检索功能,根据条件查询出来180万条数据 ,按索引列排序 , 很慢。 求解决方案啊 。
select rownum as rowno, t.myid,t.searchorg,t.title,t.abstract,t.author,t.publication_date_time,t.syear,t.ibz,t.subject,t.surl
from kjbg_ysdata t
where ( contains(TITLE , 'the')>0 or contains(ABSTRACT , 'the')>0 or contains(Subject , 'the')>0 )
order by t.myid ;
不加order by 可以秒出. 加order by 几分钟都出不来 .