Set operations are slow, not optimized.
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3CFB8D8E.B1B1C4FA_at_exesolutions.com...
> Ryan Gaffuri wrote:
>
> > Also, are there times when loading a table into a pl/sql table in
> > memory might speed up performance of a select statement that is based
> > on many join conditions? For example, I need to indentify duplicate
> > data in two tables based on about 30 of the 40 columns in the two
> > tables. Im currently doing a join on each of these 30 columns to look
> > for the duplicates. This is really slow. Would using a pl/sql table
> > improve performance?
>
> Why a join?
>
> Why not set operators such as INTERSECT or MINUS?
>
> Daniel Morgan
>
Received on Mon Jun 03 2002 - 23:45:30 CDT
