Re: Question about using a pl/sql table to improve performance of a query

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 - 10:38:59 CDT