请教:all_all_tables left outer join all_tab_comments 速度奇慢,如何调优,谢谢!
ycbao 2009-05-26 10:21:51 请教:all_all_tables left outer join all_tab_comments 速度奇慢,如何调优,谢谢!
all_all_tables 记录数21400条; all_tab_comments 记录数25300条
数据库 ORACLE10.1.0.2 on AIX UNIX
语句:
select t1.owner owner,t1.table_name table_name
from all_all_tables t1
left outer join all_tab_comments t2 on t1.owner=t2.owner and t1.table_name=t2.table_name
where t1.owner in ('ABCD') and t1.owner not in ('SYS','SYSTEM')
order by owner,table_name;
好像去掉ORDER By 快一点,大概在2分钟,加了ORDER BY 时间在几个小时
请教,如何调优?谢谢!