Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Cant figure out why query is so poor, or is it?
Oracle 8.1.6 Sun Sparc Solaris 2.7
We have a query runing in our production database that is showing an
average
number of buffer gets per execution of 156. We want to tune this query
but when
we do "set autotrace on" it shows only 3 consistant gets -- the query
is so
basic, this is what you would expect. The only trigger on the table is
for the insert of new rows. I am stuck for a reason why this is
happening and therefore how to tune it. Here are
the facts...
1 delete from premium_risk_split
2* where policy_line_seq_no = 137009
PRODCOPY>/
3 rows deleted.
Execution Plan
Statistics
Which is what you would expect however.... SQL_TEXT
---------- ----------- ----------------------DELETE FROM PREMIUM_RISK_SPLIT WHERE POLICY_LINE_SEQ_NO = :b1 129787 20354790 156.83227
Any ideas?
Thanks
Ralph Received on Thu Feb 14 2002 - 04:34:09 CST