[Tuning] SQL request takes a long time to run
Hello,
A following request takes a long time to run (database version 8.1.7.4.0) :
SELECT CACC_HT_REEL,CACC_QTE_BAS
FROM ACCCDE WHERE CACC_NOCDE=:b1 AND CACC_LIG=:b2 AND CACC_FOLIO=:b3 AND CACC_TYPEACC=:b4 AND CACC_COMENT_D=:b5
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 458315 91.94 92.08 0 0 0 0
Execute 458315 304.89 301.64 0 0 0 0
Fetch 510019 35.63 33.83 129 1479826 0 51705
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1426649 432.46 427.55 129 1479826 0 51705
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 40 (FABBGQ)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS BY INDEX ROWID ACCCDE
1 INDEX RANGE SCAN (object id 933837)