We made some tests and it occours that, when we used mode ALL_ROWS,
query is performing more faster. But we still don't know, what caused
this situation.
We suppose that there is a global problem with reading and writing
data to disk (we've got raid on our system)...
Thanks
Marek Kawczyński
"Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:<3C395AC2.50C42023_at_exesolutions.com>...
> 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 Tue Jan 08 2002 - 07:55:31 CST
