Completes in a reasonable amount of time, it still runs 200-300% longer than the other options; but that only equates to 2-4s. I still have to add and remove the index for this single statement, but it's feasible.

EDIT: Unfortunately in my real world case (which compares 5 values rather than 2) this still results in unsatisfactory performance. (3 minutes as opposed to 2 seconds for other options)]]>tmcallister2013-02-04T23:34:53-00:00Re: Assigning an IDhttp://www.orafaq.com/forum/./mv/msg/186075/576485/#msg_576485
tmcallister2013-02-05T15:23:01-00:00