Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.chainon-marquant.org!nntpfeed.proxad.net!feeder1-1.proxad.net!proxad.net!feeder1-2.proxad.net!74.125.46.80.MISMATCH!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail From: Antony Newsgroups: comp.databases.sybase Subject: Re: Total estimated I/O cost for statement Date: Tue, 1 Nov 2011 20:03:42 -0700 (PDT) Organization: http://groups.google.com Lines: 12 Message-ID: <19295582.1007.1320203022938.JavaMail.geo-discussion-forums@prap37> References: <54341b3c-124d-468d-8f5d-44ee527cb0d5@h5g2000vbf.googlegroups.com> <9198293.253.1319584866620.JavaMail.geo-discussion-forums@prfq1> <480aa7ef-adb7-4a74-98d9-e6256df44e26@n38g2000yqm.googlegroups.com> <7e5c26ce-784b-4562-8be9-536ab53a2d6d@j39g2000yqc.googlegroups.com> <2f3ebb64-17f6-495c-ba4b-d58e2001dc67@u24g2000pru.googlegroups.com> <9f5b363d-2d06-4eb3-aab4-a66ad5ba832f@m19g2000vbm.googlegroups.com> Reply-To: comp.databases.sybase@googlegroups.com NNTP-Posting-Host: 210.48.49.225 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Trace: posting.google.com 1320204046 20285 127.0.0.1 (2 Nov 2011 03:20:46 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 2 Nov 2011 03:20:46 +0000 (UTC) In-Reply-To: <9f5b363d-2d06-4eb3-aab4-a66ad5ba832f@m19g2000vbm.googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=210.48.49.225; posting-account=NnXtTwoAAAABgWhO-BeH3pCDvor0eHtW User-Agent: G2/1.0 X-Google-Web-Client: true Xref: x330-a1.tempe.blueboxinc.net comp.databases.sybase:555 On Tuesday, 1 November 2011 05:36:31 UTC+13, 1dg618 wrote: > | | |MERGE JOIN Operator (Join Type: Left Outer Join) (VA = 3) If merge joins are causing you troubles, I'd ignore them: 1> set merge_join off 2> go I'm loathe to recommend you disable them by default - there must be some use for them - but I have yet to see them cause anything but trouble :) At lease - try the query plan again without merge joins enabled ...