SQL & PL/SQL

Dear All,

I am trying fine tune some code and find that we have a big loop which is going to loop more than 100000 time and for each record, it in turn checks for some validation in individual tables.

I am planning to implement all the checking functionalities using join conditions. I.E. Dump all the data into some global temporary table or oracle tables of object type and implement the checking conditions using join operations, so that I can avoid the unnecessary checking for each record.

If I want to implement this, I want to know which one is better. A Global Temporary table or an Oracle Nested Tables.

Much appreciate your response.

Thanks,
MK.