欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

sql数据库走索引 怎么始终有物理读(2)_MySQL

程序员文章站 2022-04-29 23:36:22
...
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
相关标签: sql数据库 物理