Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!postnews2.google.com!not-for-mail
From: drga59@hotmail.com (Dario)
Newsgroups: comp.databases.oracle.server
Subject: Re: "select *" MUCH quicker than "select <field> from...": explanation ?
Date: 7 Jul 2004 17:53:19 -0700
Organization: http://groups.google.com
Lines: 12
Message-ID: <e409f463.0407071653.2f32a81c@posting.google.com>
References: <aba30b75.0407061025.441cc6f4@posting.google.com> <ug2me01cl85vd3tt5qc7mf60lvv8rnps15@4ax.com> <aba30b75.0407070517.317db00b@posting.google.com>
NNTP-Posting-Host: 203.16.129.129
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1089247999 29527 127.0.0.1 (8 Jul 2004 00:53:19 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 8 Jul 2004 00:53:19 +0000 (UTC)
Xref: core-easynews comp.databases.oracle.server:225185
X-Received-Date: Wed, 07 Jul 2004 17:52:27 MST (news.easynews.com)

spendius@muchomail.com (Spendius) wrote in message news:<aba30b75.0407070517.317db00b@posting.google.com>...
> Sybrand Bakker <sybrandb@hccnet.nl> wrote:
> > - compare the execution paths and/or ran EXPLAIN PLAN?
> > - traced the session ?
> 
> Below: 
> o plan when selecting only one field (which is null actually
> o  "     "     "      all fields


select  count(*) and select count(nullable field) are not same
queries, you can not compare them