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-10-25 16:21 -0700
Organization	http://groups.google.com
Message-ID	<9198293.253.1319584866620.JavaMail.geo-discussion-forums@prfq1> (permalink)
References	<54341b3c-124d-468d-8f5d-44ee527cb0d5@h5g2000vbf.googlegroups.com>

Show all headers | View raw

To answer your other question, a qualified "yes" lower is better - in the sense that the ASE optimizer will seek to minimise this value in choosing the final plan. It's possible in practice, though, that the plan producing the fastest response to your query might not be the same as the one giving the lowest *estiamted* io cost. :)

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