Re: performance approach PL/sql ?

>I plan to write a PL/SQL that basically performs a join on all the
>records and associates the row IDs of the 19 tables with the driving
>table's key and store the relationships in a new oracle table.

Sounds like something Oracle has already implemented.... they call it INDEX.

Is this query subject to repeated/constant execution ? You should tell us that.

I may be wrong, but I think you may be pretty close to violating this "rule"...."Do it with SQL if you can, otherwise do it with PL/SQL...otherwise Java sp...."

RC

>this script completes, I can just run my SQL off of the relationship
>table and get the info with a direct row id based query for all 19
>tables. This will improve performance of extracting all the 20 tables'
>data
Received on Fri Apr 05 2002 - 10:20:35 CST