Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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