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 [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
