> Are you sure this is the actual plan used? 11 seconds sounds about the
> right time for a full table scan of that many rows. Is the primary key
> column a varchar2 containing a number value with the deletion being
> passed a number i.e. delete from <table> where <column> = 1234. This
> will cause an implicit to_number conversion on the column, resulting
> in a full table scan which is not reflected in the explain plan.
It is disapointing that oracle does not relay that type of information in explain
plan. To me, anything implicit should be reported. How many times have you run
into a bug caused by something that turned out to be implicit. :)
Received on Wed Dec 15 1999 - 19:41:34 CST
