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

来源:互联网 时间:1970-01-01

    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   policyn

相关阅读:
Top