tkprof and cardinality
Hi,
i have the following output in tkprof :
SELECT RARTIT_RARCAULOC,RARTIT_BURSACCI_,RARTIT_FECHRARO_
FROM RARTIT
WHERE RARTIT_ESCENA_CODIGO___ = :B4
AND RARTIT_PORTAF_CODIGO___ = :B3
AND RARTIT_TITULO_NUMERO___ = :B2
AND RARTIT_FECHRARO_ <= :B1
ORDER BY RARTIT_FECHRARO_ DESC
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 18 0.00 0.00 0 0 0 0
Execute 18 0.00 0.01 0 0 0 0
Fetch 12134 6.92 98.16 11952 24294 0 12124
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 12170 6.92 98.18 11952 24294 0 12124
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: 34 (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
380 TABLE ACCESS BY INDEX ROWID RARTIT (cr=763 pr=382 pw=0 time=1946733 us cost=82 size=2430 card=81)
i have the following output in tkprof :
SELECT RARTIT_RARCAULOC,RARTIT_BURSACCI_,RARTIT_FECHRARO_
FROM RARTIT
WHERE RARTIT_ESCENA_CODIGO___ = :B4
AND RARTIT_PORTAF_CODIGO___ = :B3
AND RARTIT_TITULO_NUMERO___ = :B2
AND RARTIT_FECHRARO_ <= :B1
ORDER BY RARTIT_FECHRARO_ DESC
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 18 0.00 0.00 0 0 0 0
Execute 18 0.00 0.01 0 0 0 0
Fetch 12134 6.92 98.16 11952 24294 0 12124
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 12170 6.92 98.18 11952 24294 0 12124
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: 34 (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
380 TABLE ACCESS BY INDEX ROWID RARTIT (cr=763 pr=382 pw=0 time=1946733 us cost=82 size=2430 card=81)
0