Hi-
In my last post I pasted in the wrong version of my view. In an attempt to
keep the "both" index from being used, I have removed the line that selects
"actor_case_assignment.actor_id," and the explain plan is still the same.
Just delete this line from my earlier post, and it will be correct.
-Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/