Re: Oracle 8.0.5 on HP-UX - optimizer problem

Did you analyzed the tables? Did you run Explain Plan?

Daniel A. Morgan

Marek Kawczy?ski wrote:

> I have some problems with performance of delete query.
> My query is like :
> delete from table1
> where id in (select id from table1
> minus
> select id from table2)
> or field1 = ...
> or field2 = ...;
> In this case oracle making in very long time (about 30 minutes)
> if i reorder this in:
> delete from table1
> where field1 = ...
> or field2 = ...
> or id in (select id from table1
> minus
> select id from table2);
> time of doing this is about 5 secs.
> Whats going on, is that a bug?
> My optimiser is in mode choose. There was ok, about 2 weeks ago. Now
> is like in that case.
> Please help me...
Received on Mon Jan 07 2002 - 02:22:26 CST