Hi,
I've been doing some basic testing on sort/merge and hash joins and
was wondering why the CBO often prefers to use the sort/merge join
rather than the hash join?
I can't find any documentation anywhere!
Many thanks in advance
Si
- WAS CANCELLED BY =======:
From: trundlebus1_at_hotmail.com (Ian)
Control: cancel <f2e963ee.0201250403.17d073b7_at_posting.google.com>
Subject: cmsg cancel <f2e963ee.0201250403.17d073b7_at_posting.google.com>
Date: Mon, 28 Jan 2002 00:31:55 GMT
Message-ID: <cancel.f2e963ee.0201250403.17d073b7_at_posting.google.com>
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!cert.uni-stuttgart.de!news.belwue.de!fu-berlin.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!diablo.netcom.net.uk!netcom.net.uk!newsfeed.icl.net!newsfeed.frii.com!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40723847
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 - 06:03:30 CST