Re: help: query tuning

Itīs hard to believe that you canīt create any index ( even non-uniqu= e
will help you ).
OK.
If you use ORACLE 7.3.4 or later use the parallel hint as folows :

delete /*+ parallel( table_a, 32 ) */ from ...

Hans Pfeiffer

Pat Minnis wrote:
> =

> No indexes? No primary keys? A relational database?
> Tongue in check of course :-)
> =

> <ewong74_at_netscape.net> wrote in message news:7m60pg$o6a$1_at_nnrp1.deja.co=
m...
> > Hi,
> >
> > I have the following query which take me 2 hour to finish:
> >
> > delete from table_a a where term_id in
> > (select term_id from table_b b where a.code = b.code);
> >
> > table_a has 300k rows, table_b has 100k rows.
> > Both tables have no indexes and i cannot create any indexes on them.
> > When I do an explain plan, it looks like oracle are doing full table
> > scan for both tables.
> >
> > Please help. Thanx.
> >
> > Ed
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
Received on Sat Jul 17 1999 - 14:36:38 CDT