Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.sybase > #539
| Path | csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!nx01.iad01.newshosting.com!newshosting.com!69.16.185.11.MISMATCH!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
|---|---|
| From | Antony <albion26.eve@gmail.com> |
| Newsgroups | comp.databases.sybase |
| Subject | Re: Total estimated I/O cost for statement |
| Date | Tue, 25 Oct 2011 16:21:06 -0700 (PDT) |
| Organization | http://groups.google.com |
| Lines | 5 |
| Message-ID | <9198293.253.1319584866620.JavaMail.geo-discussion-forums@prfq1> (permalink) |
| References | <54341b3c-124d-468d-8f5d-44ee527cb0d5@h5g2000vbf.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 |
| Content-Transfer-Encoding | quoted-printable |
| X-Trace | posting.google.com 1319585212 29187 127.0.0.1 (25 Oct 2011 23:26:52 GMT) |
| X-Complaints-To | groups-abuse@google.com |
| NNTP-Posting-Date | Tue, 25 Oct 2011 23:26:52 +0000 (UTC) |
| In-Reply-To | <54341b3c-124d-468d-8f5d-44ee527cb0d5@h5g2000vbf.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:539 |
Show key headers only | 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
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