我的一个sql单从执行计划来看很好,但是运行起来效率很差。后来看数据发现IDX_PROBPRN_REGION_CODE的结果集很大,NESTED LOOPS用在这里就会很慢。听说过这种情况下用MERGE JOIN会很高效,但是我不清楚hint怎么指定使用MERGE JOIN。请高人指点一下,谢谢啦!SELECT STATEMENT, GOAL = CHOOSE
SORT UNIQUE
NESTED LOOPS
NESTED LOOPS
TABLE ACCESS BY INDEX ROWID Object owner=LIFEREPT Object name=PROBPRN
INDEX RANGE SCAN Object owner=LIFEREPT Object name=IDX_PROBPRN_REGION_CODE
TABLE ACCESS BY INDEX ROWID Object owner=LIFEREPT Object name=PROBPRN_TRACE
INDEX RANGE SCAN Object owner=LIFEREPT Object name=IDX_PROBPRN_TRACE
TABLE ACCESS BY INDEX ROWID Object owner=LIFEREPT Object name=PROBPRN_DESC
INDEX RANGE SCAN Object owner=LIFEREPT Object name=IDX_PROBPRN_DESC
SORT UNIQUE
NESTED LOOPS
NESTED LOOPS
TABLE ACCESS BY INDEX ROWID Object owner=LIFEREPT Object name=PROBPRN
INDEX RANGE SCAN Object owner=LIFEREPT Object name=IDX_PROBPRN_REGION_CODE
TABLE ACCESS BY INDEX ROWID Object owner=LIFEREPT Object name=PROBPRN_TRACE
INDEX RANGE SCAN Object owner=LIFEREPT Object name=IDX_PROBPRN_TRACE
TABLE ACCESS BY INDEX ROWID Object owner=LIFEREPT Object name=PROBPRN_DESC
INDEX RANGE SCAN Object owner=LIFEREPT Object name=IDX_PROBPRN_DESC
解决方案 »
- 帮忙写个select语句
- The Network Adapter could not establish the connection
- spfileorcl.ora被我不小心删除了,又没有备份,怎么恢复啊,那位大虾救救啊!
- 请教两个关于oracle存储过程的问题。
- 一定要建存储过程才能执行吗?
- 修改
- 请教Oracle9i的SQL*PLUS与SQL*PLUSWorkSheet有什么区别么?同一条命令为什么结果不同?是缓冲么?
- oracle递归查询问题
- impdp命令导入新用户,和导入已有用户有什么区别?
- 远程连接数据库出错ORA-12545
- oracle 中 如何编写 包 实现SQL动态查询
- 請教高手,如果用P/L SQL得到一組數據的所有組合情況?
不清楚什么问题了