Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!sjc70.webusenet.com!news.webusenet.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.server Subject: Re: UNion Versus Or Date: Tue, 09 Sep 2003 17:23:47 -0700 Organization: ATS Message-ID: <1063153407.221224@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <3F5E1CFB.5C3DBA9@Gunner.Sabot.Spam.On.Loaded.FIRE> In-Reply-To: <3F5E1CFB.5C3DBA9@Gunner.Sabot.Spam.On.Loaded.FIRE> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@pond178.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 29 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242745 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@x.washington.edu (replace 'x' with a 'u' to reply)