sql數據庫走索引怎么始終有物理讀(2)_MySQL
來源：懂視網
責編：小采
時間：2020-11-09 17:57:26
sql數據庫走索引怎么始終有物理讀(2)_MySQL
sql數據庫走索引怎么始終有物理讀(2)_MySQL:bitsCN.com 0 0 12 0 05 Fetch 2 0.00 0.00 0 1 0 1 06 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- 07 total 4 0.79 0.90 0 1 12 1 08 09 Misses in library cache during parse: 1 10 Optimizer mode: ALL_ROWS 11 Pa
導讀sql數據庫走索引怎么始終有物理讀(2)_MySQL:bitsCN.com 0 0 12 0 05 Fetch 2 0.00 0.00 0 1 0 1 06 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- 07 total 4 0.79 0.90 0 1 12 1 08 09 Misses in library cache during parse: 1 10 Optimizer mode: ALL_ROWS 11 Pa
bitsCN.com
0 0 12 0
05 Fetch 2 0.00 0.00 0 1 0 1
06 ------- ------ -------- ---------- ---------- ---------- ---------- ----------
07 total 4 0.79 0.90 0 1 12 1
08
09 Misses in library cache during parse: 1
10 Optimizer mode: ALL_ROWS
11 Parsing user id: 64
12
13 Rows Row Source Operation
14 ------- ---------------------------------------------------
15 1 SORT AGGREGATE
16 0 FILTER
17 0 INDEX RANGE SCAN IND_T_PREBM4 (object id 38674)
18
19 Elapsed times include waiting on following events:
20 Event waited on Times Max. Wait Total Waited
21 ---------------------------------------- Waited ---------- ------------
22 direct path write 1 0.00 0.00
23 SQL*Net message to client 2 0.00 0.00
24 SQL*Net message from client 2 27.20 27.22
1 insert into sys.fga_log$(sessionid,timestamp#,dbuid,osuid,obj$schema,obj$name,
2 policynbitsCN.com
聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
sql數據庫走索引怎么始終有物理讀(2)_MySQL
sql數據庫走索引怎么始終有物理讀(2)_MySQL:bitsCN.com 0 0 12 0 05 Fetch 2 0.00 0.00 0 1 0 1 06 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- 07 total 4 0.79 0.90 0 1 12 1 08 09 Misses in library cache during parse: 1 10 Optimizer mode: ALL_ROWS 11 Pa
