- 博客(6)
- 收藏
- 关注
原创 hint UNNEST 可以提示CBO进行Subquery Unnesting
用hint NO_UNNEST 可以禁止CBO 进行 Subquery Unnesting hint UNNEST 可以提示CBO进行Subquery Unnesting 上面HINT只能放在子查询里面 select count(*) as col_0_0_ from WF_PUB_FORM_DATA pubformdat0_ where (1 = 1) and (p...
2019-07-04 09:53:14 151
原创 禁止CBO进行子查询扩展
用hint NO_UNNEST 可以禁止CBO 进行 Subquery Unnesting hint UNNEST 可以提示CBO进行Subquery Unnesting 1.NO_UNNEST SQL> set linesize 200 SQL> set pagesize 200 SQL> explain plan for select count(*) from ...
2019-07-04 09:40:23 126
原创 alter session set _unnest_subquery=false;
alter session set _unnest_subquery=false; 不让它进行子查询改写 select count(*) from test o where object_id>(select avg(object_id) from test i where i.object_type=o.object_type); SQL> set linesize 200...
2019-07-04 09:28:09 417
原创 hint UNNEST 可以提示CBO进行Subquery Unnesting
SQL> set linesize 200 SQL> set pagesize 200 SQL> ALTER SESSION SET STATISTICS_LEVEL=ALL; 会话已更改。 SQL> select sql_text from v$sqlarea where (address, hash_value) in (select DECO...
2019-07-03 10:58:44 190
原创 阻止子查询进行 Subquery Unnesting
hint NO_UNNEST 可以禁止CBO 进行 Subquery Unnesting SQL> set linesize 200 SQL> set pagesize 200 SQL> explain plan for select * from test1 where owner='SCOTT' and object_id in(select objec...
2019-07-03 08:57:27 148
原创 子查询非嵌套(subquery unnesting) FILTER
SQL> set linesize 200 SQL> set pagesize 200 SQL> explain plan for select * from test1 where owner='SCOTT' or object_id in (select object_id from test2 where owner='SCOTT'); 已解释。 SQL> se...
2019-07-02 19:46:35 336
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人