PL/SQL (MOSC)

MOSC Banner

Plsql Collection - logic issue

edited Apr 18, 2012 10:59PM in PL/SQL (MOSC) 5 commentsAnswered
I'm having an issue getting a piece of code optimized. The code performs the amount of inserts that I want but it reads table 2 multiple times.I don't want this as table 2 is quite large and it's too much i/o. I'd like to load table 2 in memory structure and not perform a physical read on it.
Here is the scenario and I provide sample code.

I have two tables. A select on table1 defines the amount of inserts I perform and 1 column for the insert on table3, table2 provides the data (millions of rows) for the insert on table3.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center