Skip to Content
0
Former Member
Jul 15, 2010 at 07:04 AM

Performance in Nested Loops

38 Views

Hii,

I have a strange problem on hand.

I have nested loops which contains a lot of records approx 50,000

I have used parallel cursor technique which uses to sort the tables beforehand.

When I use parallel cursor I get wrong results due to the fact I'm sorting tables.

Which other techniques do I have to make this nested loop faster.

What about Field Symbols.

Varun