Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.sybase > #540

Re: Index contains all needed columns. Base table will not be read.

Path csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!border3.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From Antony <albion26.eve@gmail.com>
Newsgroups comp.databases.sybase
Subject Re: Index contains all needed columns. Base table will not be read.
Date Tue, 25 Oct 2011 16:30:19 -0700 (PDT)
Organization http://groups.google.com
Lines 1
Message-ID <29014839.261.1319585419640.JavaMail.geo-discussion-forums@pref15> (permalink)
References <b1ae55ff-4679-4895-a3fa-254caa98dfdf@c1g2000vbw.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 1319585508 32095 127.0.0.1 (25 Oct 2011 23:31:48 GMT)
X-Complaints-To groups-abuse@google.com
NNTP-Posting-Date Tue, 25 Oct 2011 23:31:48 +0000 (UTC)
In-Reply-To <b1ae55ff-4679-4895-a3fa-254caa98dfdf@c1g2000vbw.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:540

Show key headers only | View raw


Can you post the SQL and two query plans in full? Then we might be able to help further...

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


Thread

Index contains all needed columns. Base table will not be read. 1dg618 <1dg618@gmail.com> - 2011-10-25 15:46 -0700
  Re: Index contains all needed columns. Base table will not be read. Antony <albion26.eve@gmail.com> - 2011-10-25 16:30 -0700
  Re: Index contains all needed columns. Base table will not be read. Derek Asirvadem <derek.asirvadem@gmail.com> - 2011-10-28 23:08 -0700
    Re: Index contains all needed columns. Base table will not be read. 1dg618 <1dg618@gmail.com> - 2011-10-31 09:37 -0700
      Re: Index contains all needed columns. Base table will not be read. Derek Asirvadem <derek.asirvadem@gmail.com> - 2011-11-01 18:06 -0700

csiph-web