Performance Tuning - unavoidable nested loops.

Hi Experts,

I need to improve the performance of unavoidable nested loops.

In TIPS&TRICKS of SE300 tool i got PARALLEL CURSOR method to improve the nested loop performance.

I took one program and tested by using both methods...below is the conclusions..

Overall execution time is less in case of PARALLEL CURSOR but time taken in database execution is more in this method (As per SE tool analysis)

Overall execution time is more in case of straight forward nested loops but time taken in database execution is less in this method (As per SE tool analysis)

My doubt is WHICH METHOD I CAN USE....

Please guide me....

Thanks in Advance

Edited by: Julius Bussche on Jan 19, 2009 11:23 AM

Please use meaningfull subject titles