我原始的SQL花费是如下
统计信息
----------------------------------------------------------
1393 recursive calls
0 db block gets
45282 consistent gets
619 physical reads
0 redo size
3797 bytes sent via SQL*Net to client
420 bytes received via SQL*Net from client
10 SQL*Net roundtrips to/from client
12 sorts (memory)
0 sorts (disk)
50 rows processed我改完后如下
统计信息
----------------------------------------------------------
1890 recursive calls
0 db block gets
33237 consistent gets
624 physical reads
0 redo size
3797 bytes sent via SQL*Net to client
420 bytes received via SQL*Net from client
10 SQL*Net roundtrips to/from client
12 sorts (memory)
0 sorts (disk)
50 rows processed我想问改好后的是不是核算
统计信息
----------------------------------------------------------
1393 recursive calls
0 db block gets
45282 consistent gets
619 physical reads
0 redo size
3797 bytes sent via SQL*Net to client
420 bytes received via SQL*Net from client
10 SQL*Net roundtrips to/from client
12 sorts (memory)
0 sorts (disk)
50 rows processed我改完后如下
统计信息
----------------------------------------------------------
1890 recursive calls
0 db block gets
33237 consistent gets
624 physical reads
0 redo size
3797 bytes sent via SQL*Net to client
420 bytes received via SQL*Net from client
10 SQL*Net roundtrips to/from client
12 sorts (memory)
0 sorts (disk)
50 rows processed我想问改好后的是不是核算
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货