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 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