Re: Total estimated I/O cost for statement

From	Antony <albion26.eve@gmail.com>
Newsgroups	comp.databases.sybase
Subject	Re: Total estimated I/O cost for statement
Date	2011-11-01 20:03 -0700
Organization	http://groups.google.com
Message-ID	<19295582.1007.1320203022938.JavaMail.geo-discussion-forums@prap37> (permalink)
References	(1 earlier) <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>

Show all headers | View raw

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 ...

Back to comp.databases.sybase | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Total estimated I/O cost for statement 1dg618 <1dg618@gmail.com> - 2011-10-25 15:52 -0700
  Re: Total estimated I/O cost for statement albion26.eve@gmail.com - 2011-10-25 16:15 -0700
  Re: Total estimated I/O cost for statement Antony <albion26.eve@gmail.com> - 2011-10-25 16:21 -0700
    Re: Total estimated I/O cost for statement 1dg618 <1dg618@gmail.com> - 2011-10-25 17:13 -0700
      Re: Total estimated I/O cost for statement 1dg618 <1dg618@gmail.com> - 2011-10-25 17:20 -0700
        Re: Total estimated I/O cost for statement Derek Asirvadem <derek.asirvadem@gmail.com> - 2011-10-28 23:21 -0700
          Re: Total estimated I/O cost for statement 1dg618 <1dg618@gmail.com> - 2011-10-31 09:36 -0700
            Re: Total estimated I/O cost for statement Derek Asirvadem <derek.asirvadem@gmail.com> - 2011-11-01 17:54 -0700
            Re: Total estimated I/O cost for statement Antony <albion26.eve@gmail.com> - 2011-11-01 20:03 -0700
              Re: Total estimated I/O cost for statement 1dg618 <1dg618@gmail.com> - 2011-11-02 09:39 -0700
                Re: Total estimated I/O cost for statement Derek Asirvadem <derek.asirvadem@gmail.com> - 2011-11-02 14:45 -0700
                Re: Total estimated I/O cost for statement 1dg618 <1dg618@gmail.com> - 2011-11-04 06:11 -0700
                Re: Total estimated I/O cost for statement Derek Asirvadem <derek.asirvadem@gmail.com> - 2011-11-06 06:33 -0800

csiph-web