Re: UNion Versus Or

Tim Marshall wrote:

>JOhn Palinski's book recommends using Union set operators instead of OR
>conjunctions in the where clause with respect to obtaining better
>perfromance. I was reminded of this when I was browsing through some of
>the examples JOhn Russell provided me in a search URL in another thread
>(http://otn.oracle.com/pls/db92/db92.drilldown?remark=&word=inline+views&book=&preference=).
>
>How would I "unionize" something like this:
>
>
>

Contact the Teamsters.

Sorry ... I just couldn't resist.

My advice would be to use advice in books as guidance. Most of it has value when viewed that way and almost no value when followed blindly.

In your case ... I wouldn't. I'd use native dynamic SQL and put the query together dynamically.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)