How can I improve the performance of a compensation Plan
Plan Input:SUM QUANTITY
Output : Rate Table Result
Interval : JUL to AUG
Type:GBI
Rate Table Type: Amount
Rate Table e.g
0-1000000 30000
1000000-2000000 40000
2000000-30000000 50000
3000000-9999999999 10000000
Any help on this will be highly appreciated.