11.2 繫結變數執行計劃怎麼這樣？求助！
本來是想在11G下實驗一下http://www.itpub.net/thread-1323480-1-1.html
沒想到，發現了新的問題，新開帖求助
C:\Users\Administrator>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on 星期一 7月 12 15:14:21 2010
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn test/test
已連線。
SQL> create table t (id varchar2(10),text varchar2(4000));
表已建立。
SQL> insert into t select '1',object_name from dba_objects;
已建立63859行。
SQL> insert into t values( '2','aaa');
已建立 1 行。
SQL> commit;
提交完成。
SQL> select id,count(*) from t group by id;
ID COUNT(*)
---------- ----------
1 63859
2 1
SQL> create index t_idx on t(id);
索引已建立。
SQL> exec dbms_stats.gather_table_stats(user,'T',method_opt=>'for all indexed co
lumns',cascade=>true);
PL/SQL 過程已成功完成。
SQL> var fid varchar2;
SQL> exec :fid := '2';
PL/SQL 過程已成功完成。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED'));
SQL_ID fprdgayw5y5vq, child number 0
-------------------------------------
select * from t where id=:fid
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 97 (100)| |
|* 1 | TABLE ACCESS FULL| T | 31930 | 810K| 97 (2)| 00:00:02 |
--------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1 / T@SEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 4)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :FID (VARCHAR2(30), CSID=852): '2'
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("ID"=:FID)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "ID"[VARCHAR2,10], "T"."TEXT"[VARCHAR2,4000]
已選擇48行。
沒有設定_optim_peek_user_binds，並且，繫結變數也進行了bind peeking，為什麼還選擇全表掃描？
做一下10053
SQL> alter system flush shared_pool;
系統已更改。
SQL> alter session set events '10053 trace name context forever';
會話已更改。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> alter session set events '10053 trace name context off';
會話已更改。
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T Alias: T
#Rows: 63860 #Blks: 370 AvgRowLen: 26.00
Index Stats::
Index: T_IDX Col#: 1
LVLS: 1 #LB: 116 #DK: 2 LB/K: 58.00 DB/K: 136.00 CLUF: 273.00
Access path analysis for T
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T[T]
*** 2010-07-12 15:16:49.169
** Performing dynamic sampling initial checks. **
Column (#1):
NewDensity:0.500000, OldDensity:0.000008 BktCnt:5458, PopBktCnt:5458, PopValCnt:1, NDV:2
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
** Dynamic sampling initial checks returning FALSE.
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Table: T Alias: T
Card: Original: 63860.000000 Rounded: 31930 Computed: 31930.00 Non Adjusted: 31930.00
Access Path: TableScan
Cost: 97.32 Resp: 97.32 Degree: 0
Cost_io: 96.00 Cost_cpu: 16045533
Resp_io: 96.00 Resp_cpu: 16045533
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Access Path: index (AllEqRange)
Index: T_IDX
resc_io: 195.00 resc_cpu: 13203631
ix_sel: 0.500000 ix_sel_with_filters: 0.500000
Cost: 196.08 Resp: 196.08 Degree: 1
Best:: AccessPath: TableScan
Cost: 97.32 Degree: 1 Resp: 97.32 Card: 31930.00 Bytes: 0
***************************************
============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 97 | |
| 1 | TABLE ACCESS FULL | T | 31K | 811K | 97 | 00:00:02 |
-------------------------------------+-----------------------------------+
Predicate Information:
----------------------
1 - filter("ID"=:FID)
Content of other_xml column
===========================
db_version : 11.2.0.1
parse_schema : TEST
plan_hash : 1601196873
plan_hash_2 : 2498539100
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=852
char format=1
max length=32
value=2
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 4)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
去掉動態取樣試試
SQL> alter session set optimizer_dynamic_sampling=0;
會話已更改。
SQL> alter system flush shared_pool;
系統已更改。
SQL> alter session set events '10053 trace name context forever';
會話已更改。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> alter session set events '10053 trace name context off';
會話已更改。
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T Alias: T
#Rows: 63860 #Blks: 370 AvgRowLen: 26.00
Index Stats::
Index: T_IDX Col#: 1
LVLS: 1 #LB: 116 #DK: 2 LB/K: 58.00 DB/K: 136.00 CLUF: 273.00
Access path analysis for T
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T[T]
Column (#1):
NewDensity:0.500000, OldDensity:0.000008 BktCnt:5458, PopBktCnt:5458, PopValCnt:1, NDV:2
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Table: T Alias: T
Card: Original: 63860.000000 Rounded: 31930 Computed: 31930.00 Non Adjusted: 31930.00
Access Path: TableScan
Cost: 97.32 Resp: 97.32 Degree: 0
Cost_io: 96.00 Cost_cpu: 16045533
Resp_io: 96.00 Resp_cpu: 16045533
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Access Path: index (AllEqRange)
Index: T_IDX
resc_io: 195.00 resc_cpu: 13203631
ix_sel: 0.500000 ix_sel_with_filters: 0.500000
Cost: 196.08 Resp: 196.08 Degree: 1
Best:: AccessPath: TableScan
Cost: 97.32 Degree: 1 Resp: 97.32 Card: 31930.00 Bytes: 0
***************************************
============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 97 | |
| 1 | TABLE ACCESS FULL | T | 31K | 811K | 97 | 00:00:02 |
-------------------------------------+-----------------------------------+
Predicate Information:
----------------------
1 - filter("ID"=:FID)
Content of other_xml column
===========================
db_version : 11.2.0.1
parse_schema : TEST
plan_hash : 1601196873
plan_hash_2 : 2498539100
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=852
char format=1
max length=32
value=2
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 0)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
不是動態取樣的緣故，看看是否直方圖的問題？
SQL> exec dbms_stats.gather_table_stats(user,'T',method_opt=>'for all indexed co
lumns size 1',cascade=>true);
PL/SQL 過程已成功完成。
SQL> alter system flush shared_pool;
系統已更改。
SQL> alter session set events '10053 trace name context forever';
會話已更改。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> alter session set events '10053 trace name context off';
會話已更改。
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T Alias: T
#Rows: 63860 #Blks: 370 AvgRowLen: 26.00
Index Stats::
Index: T_IDX Col#: 1
LVLS: 1 #LB: 116 #DK: 2 LB/K: 58.00 DB/K: 136.00 CLUF: 273.00
Access path analysis for T
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T[T]
Table: T Alias: T
Card: Original: 63860.000000 Rounded: 31930 Computed: 31930.00 Non Adjusted: 31930.00
Access Path: TableScan
Cost: 97.32 Resp: 97.32 Degree: 0
Cost_io: 96.00 Cost_cpu: 16045533
Resp_io: 96.00 Resp_cpu: 16045533
Access Path: index (AllEqRange)
Index: T_IDX
resc_io: 195.00 resc_cpu: 13203631
ix_sel: 0.500000 ix_sel_with_filters: 0.500000
Cost: 196.08 Resp: 196.08 Degree: 1
Best:: AccessPath: TableScan
Cost: 97.32 Degree: 1 Resp: 97.32 Card: 31930.00 Bytes: 0
***************************************
============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 97 | |
| 1 | TABLE ACCESS FULL | T | 31K | 811K | 97 | 00:00:02 |
-------------------------------------+-----------------------------------+
Predicate Information:
----------------------
1 - filter("ID"=:FID)
Content of other_xml column
===========================
db_version : 11.2.0.1
parse_schema : TEST
plan_hash : 1601196873
plan_hash_2 : 2498539100
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=852
char format=1
max length=32
value=2
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 0)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
沒想到，發現了新的問題，新開帖求助
C:\Users\Administrator>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on 星期一 7月 12 15:14:21 2010
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn test/test
已連線。
SQL> create table t (id varchar2(10),text varchar2(4000));
表已建立。
SQL> insert into t select '1',object_name from dba_objects;
已建立63859行。
SQL> insert into t values( '2','aaa');
已建立 1 行。
SQL> commit;
提交完成。
SQL> select id,count(*) from t group by id;
ID COUNT(*)
---------- ----------
1 63859
2 1
SQL> create index t_idx on t(id);
索引已建立。
SQL> exec dbms_stats.gather_table_stats(user,'T',method_opt=>'for all indexed co
lumns',cascade=>true);
PL/SQL 過程已成功完成。
SQL> var fid varchar2;
SQL> exec :fid := '2';
PL/SQL 過程已成功完成。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED'));
SQL_ID fprdgayw5y5vq, child number 0
-------------------------------------
select * from t where id=:fid
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 97 (100)| |
|* 1 | TABLE ACCESS FULL| T | 31930 | 810K| 97 (2)| 00:00:02 |
--------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1 / T@SEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 4)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :FID (VARCHAR2(30), CSID=852): '2'
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("ID"=:FID)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "ID"[VARCHAR2,10], "T"."TEXT"[VARCHAR2,4000]
已選擇48行。
沒有設定_optim_peek_user_binds，並且，繫結變數也進行了bind peeking，為什麼還選擇全表掃描？
做一下10053
SQL> alter system flush shared_pool;
系統已更改。
SQL> alter session set events '10053 trace name context forever';
會話已更改。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> alter session set events '10053 trace name context off';
會話已更改。
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T Alias: T
#Rows: 63860 #Blks: 370 AvgRowLen: 26.00
Index Stats::
Index: T_IDX Col#: 1
LVLS: 1 #LB: 116 #DK: 2 LB/K: 58.00 DB/K: 136.00 CLUF: 273.00
Access path analysis for T
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T[T]
*** 2010-07-12 15:16:49.169
** Performing dynamic sampling initial checks. **
Column (#1):
NewDensity:0.500000, OldDensity:0.000008 BktCnt:5458, PopBktCnt:5458, PopValCnt:1, NDV:2
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
** Dynamic sampling initial checks returning FALSE.
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Table: T Alias: T
Card: Original: 63860.000000 Rounded: 31930 Computed: 31930.00 Non Adjusted: 31930.00
Access Path: TableScan
Cost: 97.32 Resp: 97.32 Degree: 0
Cost_io: 96.00 Cost_cpu: 16045533
Resp_io: 96.00 Resp_cpu: 16045533
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Access Path: index (AllEqRange)
Index: T_IDX
resc_io: 195.00 resc_cpu: 13203631
ix_sel: 0.500000 ix_sel_with_filters: 0.500000
Cost: 196.08 Resp: 196.08 Degree: 1
Best:: AccessPath: TableScan
Cost: 97.32 Degree: 1 Resp: 97.32 Card: 31930.00 Bytes: 0
***************************************
============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 97 | |
| 1 | TABLE ACCESS FULL | T | 31K | 811K | 97 | 00:00:02 |
-------------------------------------+-----------------------------------+
Predicate Information:
----------------------
1 - filter("ID"=:FID)
Content of other_xml column
===========================
db_version : 11.2.0.1
parse_schema : TEST
plan_hash : 1601196873
plan_hash_2 : 2498539100
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=852
char format=1
max length=32
value=2
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 4)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
去掉動態取樣試試
SQL> alter session set optimizer_dynamic_sampling=0;
會話已更改。
SQL> alter system flush shared_pool;
系統已更改。
SQL> alter session set events '10053 trace name context forever';
會話已更改。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> alter session set events '10053 trace name context off';
會話已更改。
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T Alias: T
#Rows: 63860 #Blks: 370 AvgRowLen: 26.00
Index Stats::
Index: T_IDX Col#: 1
LVLS: 1 #LB: 116 #DK: 2 LB/K: 58.00 DB/K: 136.00 CLUF: 273.00
Access path analysis for T
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T[T]
Column (#1):
NewDensity:0.500000, OldDensity:0.000008 BktCnt:5458, PopBktCnt:5458, PopValCnt:1, NDV:2
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Table: T Alias: T
Card: Original: 63860.000000 Rounded: 31930 Computed: 31930.00 Non Adjusted: 31930.00
Access Path: TableScan
Cost: 97.32 Resp: 97.32 Degree: 0
Cost_io: 96.00 Cost_cpu: 16045533
Resp_io: 96.00 Resp_cpu: 16045533
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Access Path: index (AllEqRange)
Index: T_IDX
resc_io: 195.00 resc_cpu: 13203631
ix_sel: 0.500000 ix_sel_with_filters: 0.500000
Cost: 196.08 Resp: 196.08 Degree: 1
Best:: AccessPath: TableScan
Cost: 97.32 Degree: 1 Resp: 97.32 Card: 31930.00 Bytes: 0
***************************************
============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 97 | |
| 1 | TABLE ACCESS FULL | T | 31K | 811K | 97 | 00:00:02 |
-------------------------------------+-----------------------------------+
Predicate Information:
----------------------
1 - filter("ID"=:FID)
Content of other_xml column
===========================
db_version : 11.2.0.1
parse_schema : TEST
plan_hash : 1601196873
plan_hash_2 : 2498539100
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=852
char format=1
max length=32
value=2
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 0)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
不是動態取樣的緣故，看看是否直方圖的問題？
SQL> exec dbms_stats.gather_table_stats(user,'T',method_opt=>'for all indexed co
lumns size 1',cascade=>true);
PL/SQL 過程已成功完成。
SQL> alter system flush shared_pool;
系統已更改。
SQL> alter session set events '10053 trace name context forever';
會話已更改。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> alter session set events '10053 trace name context off';
會話已更改。
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T Alias: T
#Rows: 63860 #Blks: 370 AvgRowLen: 26.00
Index Stats::
Index: T_IDX Col#: 1
LVLS: 1 #LB: 116 #DK: 2 LB/K: 58.00 DB/K: 136.00 CLUF: 273.00
Access path analysis for T
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T[T]
Table: T Alias: T
Card: Original: 63860.000000 Rounded: 31930 Computed: 31930.00 Non Adjusted: 31930.00
Access Path: TableScan
Cost: 97.32 Resp: 97.32 Degree: 0
Cost_io: 96.00 Cost_cpu: 16045533
Resp_io: 96.00 Resp_cpu: 16045533
Access Path: index (AllEqRange)
Index: T_IDX
resc_io: 195.00 resc_cpu: 13203631
ix_sel: 0.500000 ix_sel_with_filters: 0.500000
Cost: 196.08 Resp: 196.08 Degree: 1
Best:: AccessPath: TableScan
Cost: 97.32 Degree: 1 Resp: 97.32 Card: 31930.00 Bytes: 0
***************************************
============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 97 | |
| 1 | TABLE ACCESS FULL | T | 31K | 811K | 97 | 00:00:02 |
-------------------------------------+-----------------------------------+
Predicate Information:
----------------------
1 - filter("ID"=:FID)
Content of other_xml column
===========================
db_version : 11.2.0.1
parse_schema : TEST
plan_hash : 1601196873
plan_hash_2 : 2498539100
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=852
char format=1
max length=32
value=2
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 0)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/19423/viewspace-667815/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- [20231210]執行計劃與繫結變數.txt變數
- 【CURSOR】Oracle繫結變數、執行計劃對遊標的影響Oracle變數
- Oracle-繫結執行計劃Oracle
- sqm執行計劃的繫結
- 知識篇 | ORACLE 如何執行計劃繫結Oracle
- sqlprofile繫結執行計劃實驗測試SQL
- 執行計劃沒變，執行時快時慢是怎麼回事？
- PostgreSQL執行計劃變化SQL
- Oracle利用coe_load_sql_profile指令碼繫結執行計劃OracleSQL指令碼
- 【YashanDB知識庫】繫結引數，同一個sql多個執行計劃的問題SQL
- Oracle DB 相關常用sql彙總7【手工繫結sql執行計劃】OracleSQL
- Oracle 變數窺視引起執行計劃異常故障分析Oracle變數
- 執行計劃-1：獲取執行計劃
- Oracle 通過註釋改變執行計劃Oracle
- 在繫結變數下使用outline變數
- MySQL高階特性——繫結變數MySql變數
- [20180930]in list與繫結變數.txt變數
- [20180912]PLSLQ與繫結變數.txt變數
- Vue select 繫結動態變數Vue變數
- [20180930]in list與繫結變數個數.txt變數
- [20210120]in list與繫結變數個數.txt變數
- 分析執行計劃優化SQLORACLE的執行計劃(轉)優化SQLOracle
- [20221104]執行計劃一樣Plan hash value不同.txt
- MySQL執行計劃MySql
- SYBASE執行計劃
- MySQL 執行計劃MySql
- SQLServer統計監控SQL執行計劃突變的方法SQLServer
- 【執行計劃】Oracle獲取執行計劃的幾種方法Oracle
- PostgreSQL DBA(9) - 執行計劃資料結構SQL資料結構
- 【ORACLE】Oracle繫結變數知識梳理Oracle變數
- 繫結變數窺視測試案例變數
- Oracle 9i變數窺視引起執行計劃異常故障報告Oracle變數
- 這種執行結果裡的10.100000001，怎麼能最快改成10.1？
- 執行計劃-5：第一個子操作的變化
- 教育培訓系統是怎麼樣執行的?看完這個就懂了!
- MySQL執行計劃解析MySql
- mysql explain 執行計劃MySqlAI
- explain執行計劃分析AI
- mysql執行計劃explainMySqlAI