> We have a peculiar requirement where we need to retrieve millions of
> records from almost 15 tables.
> There are 2 master tables which has many reference columns from
almost
> 15 tables. I need to get the actual data from base tables(15 tables).
> This was taking time and so had to write functions to retrieve the
> data.
A bad idea. All you have done is force Oracle into a particular access
path it could have chosen with joins anyway, and added the overhead of
calling PL/SQL functions on top. If it was slower before you added the
functions, then Oracle must have been using a sub-optimal plan. Maybe
you need to analyze your tables? Try using explain plan or trace to
see what is happening before jumping in and crippling your SQL like you
have.
Received on Thu Oct 07 2004 - 07:34:06 CDT
