Re: slow PL/SQL function
From: robertsboyle <member21885_at_dbforums.com>
Date: Fri, 31 Jan 2003 04:21:01 -0500
Message-ID: <2463993.1044004861_at_dbforums.com>
Date: Fri, 31 Jan 2003 04:21:01 -0500
Message-ID: <2463993.1044004861_at_dbforums.com>
I am still not quite sure about the tables. You say "code is a unique number" and then replicate it in the inserts. What is the primary key of the table?
Nothing wrong with 9 joins if 9 joins are what is needed, but maybe the table design needs revisited. Also as Jim says the data will be in Oracles memory if they are being hit so much.
R.
-- Posted via http://dbforums.comReceived on Fri Jan 31 2003 - 10:21:01 CET