select from a small (under 1000 rows) table does over 3000 fetches
Hello all
I am running oracle RAC 11.2.0.4 and looking into the following select
Select dab.de_rul_id
From
dab_rul_stat dab Where dab.de_rul_id=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 3140 0.25 0.58 0 0 0 0
Fetch 3140 0.03 0.03 0 3140 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6280 0.29 0.61 0 3140 0 0
the table dab_rul_stat has under 1000 rows . The column de_rul_id is the only column in the primary key. The explain plan is unique scan of the primary key ( no reads against the table).
The table usually has couple of hundred of rows, not more than 1000. The SQL returns zero rows, but it fetches over 3000.