溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
v_gasmonthsum是個視圖,select * from v_gasmonthsum t;帶上t查詢100s都出不來,去掉t 1秒以內就出來,執行計劃一樣,有哪位遇到過,這個問題反復驗證過,不是偶然的
但是通過查詢select * from v_gasmonthsum t where rownum<1000速度卻又恢復正常,總感覺select * from v_gasmonthsum t;這個查詢方法是不是少了自動分頁提取數據的功能
以下是select * from v_gasmonthsum t執行計劃:不帶別名t的查詢計劃雷同
| 1 | Plan hash value: 984768051 |
|
|
|
|
|
|
|
|
|
|
||
| 2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3 | ------------------------------------------------------------------------------------------------------------ | ||||||||||||
| 4 | | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | | ||||||||||||
| 5 | ------------------------------------------------------------------------------------------------------------ | ||||||||||||
| 6 | | 0 | SELECT STATEMENT | | 1 | 224 | 5308 (1)| 00:01:04 | | ||||||||||||
| 7 | | 1 | NESTED LOOPS | | 1 | 224 | 5308 (1)| 00:01:04 | | ||||||||||||
| 8 | | 2 | NESTED LOOPS | | 1 | 211 | 5304 (1)| 00:01:04 | | ||||||||||||
| 9 | | 3 | NESTED LOOPS | | 1 | 117 | 5298 (1)| 00:01:04 | | ||||||||||||
| # | | 4 | VIEW | VW_SQ_1 | 213 | 11076 | 4870 (1)| 00:00:59 | | ||||||||||||
| # | | 5 | HASH GROUP BY | | 213 | 11076 | 4870 (1)| 00:00:59 | | ||||||||||||
| # | |* 6 | FILTER | | | | | | | ||||||||||||
| # | | 7 | TABLE ACCESS BY INDEX ROWID| GASOUTPUTMONTHDATA | 213 | 11076 | 4870 (1)| 00:00:59 | | ||||||||||||
| # | |* 8 | INDEX FULL SCAN | IDX_GASOUTPUTMONTHDATA | 8726 | | 4766 (1)| 00:00:58 | | ||||||||||||
| # | |* 9 | TABLE ACCESS BY INDEX ROWID | GASOUTPUTMONTHDATA | 1 | 65 | 3 (0)| 00:00:01 | | ||||||||||||
| # | |* 10 | INDEX RANGE SCAN | IDX_GASOUTPUTMONTHDATA | 1 | | 2 (0)| 00:00:01 | | ||||||||||||
| # | | 11 | INLIST ITERATOR | | | | | | | ||||||||||||
| # | | 12 | TABLE ACCESS BY INDEX ROWID | GASFACMONTHDATA | 1 | 94 | 6 (0)| 00:00:01 | | ||||||||||||
| # | |* 13 | INDEX RANGE SCAN | IDX_GASFACMONTHDATA | 1 | | 5 (0)| 00:00:01 | | ||||||||||||
| # | |* 14 | VIEW PUSHED PREDICATE | VW_SQ_2 | 1 | 13 | 4 (0)| 00:00:01 | | ||||||||||||
| # | |* 15 | FILTER | | | | | | | ||||||||||||
| # | | 16 | SORT AGGREGATE | | 1 | 55 | | | | ||||||||||||
| # | |* 17 | FILTER | | | | | | | ||||||||||||
| # | |* 18 | INDEX RANGE SCAN | IDX_GASFACMONTHDATA | 1 | 55 | 4 (0)| 00:00:01 | | ||||||||||||
| # | ------------------------------------------------------------------------------------------------------------ | ||||||||||||
| # |
|
|
|
|
|
|
|
|
|
|
|
|
|
| # | Predicate Information (identified by operation id): |
|
|
|
|
|
|
|
|||||
| # | --------------------------------------------------- |
|
|
|
|
|
|
|
|||||
| # |
|
|
|
|
|
|
|
|
|
|
|
|
|
| # | 6 - filter(201801<TO_NUMBER(TO_CHAR(SYSDATE@!,'YYYYMM'))) |
|
|
|
|
|
|||||||
| # | 8 - access("G"."YEARANDMONTH">=201801 AND "G"."YEARANDMONTH"<TO_NUMBER(TO_CHAR(SYSDATE@!,'YYYYMM' | ||||||||||||
| # | ))) |
|
|
|
|
|
|
|
|
|
|
|
|
| # | filter("G"."YEARANDMONTH">=201801 AND "G"."YEARANDMONTH"<TO_NUMBER(TO_CHAR(SYSDATE@!,'YYYYMM' | ||||||||||||
| # | ))) |
|
|
|
|
|
|
|
|
|
|
|
|
| # | 9 - filter("T"."SHAREID"="MAX(SHAREID)") |
|
|
|
|
|
|
|
|
||||
| # | 10 - access("T"."PSCODE"="ITEM_1" AND "T"."OUTPUTCODE"="ITEM_3" AND "T"."YEARANDMONTH"="ITEM_2") | ||||||||||||
| # | filter("T"."YEARANDMONTH">=201801 AND "T"."YEARANDMONTH"<TO_NUMBER(TO_CHAR(SYSDATE@!,'YYYYMM' | ||||||||||||
| # | ))) |
|
|
|
|
|
|
|
|
|
|
|
|
| # | 13 - access("T"."PSCODE"="T"."PSCODE" AND "T"."OUTPUTCODE"="T"."OUTPUTCODE" AND |
|
|
||||||||||
| # | ("T"."POLLUTANTCODE"='001' OR "T"."POLLUTANTCODE"='002' OR "T"."POLLUTANTCODE"='003') AND | ||||||||||||
| # | "T"."YEARANDMONTH"="T"."YEARANDMONTH") |
|
|
|
|
|
|
|
|||||
| # | filter("T"."YEARANDMONTH">=201801 AND "T"."YEARANDMONTH"<TO_NUMBER(TO_CHAR(SYSDATE@!,'YYYYMM' | ||||||||||||
| # | ))) |
|
|
|
|
|
|
|
|
|
|
|
|
| # | 14 - filter(SYS_OP_UNDESCEND(SYS_OP_DESCEND("SHAREID"))="MAX(SHAREID)") |
|
|
|
|||||||||
| # | 15 - filter(COUNT(*)>0 AND 201801<TO_NUMBER(TO_CHAR(SYSDATE@!,'YYYYMM'))) |
|
|
|
|||||||||
| # | 17 - filter(TO_NUMBER(TO_CHAR(SYSDATE@!,'YYYYMM'))>"T"."YEARANDMONTH" AND |
|
|
|
|||||||||
| # | 201801<="T"."YEARANDMONTH" AND 201801<TO_NUMBER(TO_CHAR(SYSDATE@!,'YYYYMM'))) |
|
|||||||||||
| # | 18 - access("G"."PSCODE"="T"."PSCODE" AND "G"."OUTPUTCODE"="T"."OUTPUTCODE" AND |
|
|
||||||||||
| # | "G"."POLLUTANTCODE"="T"."POLLUTANTCODE" AND "G"."YEARANDMONTH"="T"."YEARANDMONTH") | ||||||||||||
| # | filter("G"."YEARANDMONTH">=201801 AND "G"."YEARANDMONTH"<TO_NUMBER(TO_CHAR(SYSDATE@!,'YYYYMM' | ||||||||||||
| # | ))) |
|
|
|
|
|
|
|
|
|
|
|
|
| # |
|
|
|
|
|
|
|
|
|
|
|
|
|
| # | Note |
|
|
|
|
|
|
|
|
|
|
|
|
| # | ----- |
|
|
|
|
|
|
|
|
|
|
|
|
| # | - dynamic sampling used for this statement (level=2) |
|
|
|
|
|
|
||||||
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
