REPOST: Re: Can joins be less efficient?

From: Ilya Zvyagin 2147483647 <ziv_at_fct.ru>
Date: Fri, 25 Jan 2002 12:30:56 +0300
Message-ID: <0$--$%%%%-_---%%_$@news.noc.cabal.int>

"NoSpam" <NoSpam_at_NoSpam.com> wrote in message news:a2pj0t$sdh$1_at_ih292.ea.unisys.com...
> I'm working on the code written by somebody else. What this code does is
...
> very obvious that the two queries can be combined with a simple join. But
> this person insisted that there are times that cascaded reading of the
> resultsets can be faster than a simple join but he couldn't give me an
> example. I just wonder if it really can be true and under what circumstances

Just because there is no one.

> that reading two resultsets can be faster than a single resultset with a
> join when a common key field exists in both tables.

Never until both tables do not have qualifying indices.

WAS CANCELLED BY =======: From: "Ilya Zvyagin 2147483647" <ziv_at_fct.ru> Control: cancel <1011950836.337583_at_gatekeeper.fct.ru> Subject: cmsg cancel <1011950836.337583_at_gatekeeper.fct.ru> Date: Mon, 28 Jan 2002 03:03:10 GMT Message-ID: <cancel.1011950836.337583_at_gatekeeper.fct.ru> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.fh-hannover.de!fu-berlin.de!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40724053

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 03:30:56 CST