Убрал /*RULE*/ из V_DICACCFO
Код: |
SELECT *
FROM V_DICACCFO M
where M.NCOMPANY = 1527001
and (M.DACC_DATE >= TO_DATE('01/11/2004', 'dd/mm/yyyy'))
and (M.DACC_DATE <= TO_DATE('30/11/2004', 'dd/mm/yyyy'))
order by M.SPREF_NUMB, M.SREG_NUMB
|
До и после:
Statistics
----------------------------------------------------------
17771 recursive calls
13050 db block gets
867586 consistent gets
7849 physical reads
816 redo size
1920946 bytes sent via SQL*Net to client
31505 bytes received via SQL*Net from client
282 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
4206 rows processed
Statistics
----------------------------------------------------------
17782 recursive calls
13118 db block gets
800553 consistent gets
12882 physical reads
284 redo size
1921732 bytes sent via SQL*Net to client
31505 bytes received via SQL*Net from client
282 SQL*Net roundtrips to/from client
29 sorts (memory)
0 sorts (disk)
4206 rows processed
Во втором случае ощутимо быстрее, хотя чтений и сортировок больше. Почему?