Home >Database >Mysql Tutorial >sql数据库走索引 怎么始终有物理读(2)_MySQL

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:50:511163browse

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:MySQL学习总结_MySQLNext article:MySQL DBA 常用手册_MySQL