One more thought. Your ORDER BY could be adapted to present the cursor in the desired order if you add ASC (ascending) to the right of the first field like:

ORDER BY sequence ASC, eff_date DESC ;

Might that permit you to do without an index on the cursor?


Spencer Redfield