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.