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

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? Received on Mon Jun 03 2002 - 06:50:15 CDT