[thelist] RE: thelist digest, Vol 1 #806 - 1 msg

Martin Smith martin at blueticket.co.uk
Thu Oct 12 12:09:34 CDT 2000


Absolutely none at all, it's just an alias...

From: Martin Smith
mailto:martin at blueticket.co.uk

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]
Sent: 12 October 2000 18:00
To: thelist at lists.evolt.org
Subject: thelist digest, Vol 1 #806 - 1 msg



Send thelist mailing list submissions to
	thelist at lists.evolt.org

To subscribe or unsubscribe via the web, visit
	http://lists.evolt.org/mailman/listinfo/thelist
or, via email, send a message with subject or body 'help' to
	thelist-request at lists.evolt.org
You can reach the person managing the list at
	thelist-admin at lists.evolt.org

When replying, please edit your Subject line so it is more specific than
"Re: Contents of thelist digest..."


Today's Topics:

  1. Re: Select * (Seb Barre)

--__--__--

Message: 1
Date: Thu, 12 Oct 2000 12:34:41 -0400
To: thelist at lists.evolt.org
From: Seb Barre <sebastien at oven.com>
Subject: Re: [thelist] Select *
Reply-To: thelist at lists.evolt.org

At 09:26 AM 10/12/2000 -0700, you wrote:
>In addition:
>
>- If you are only selecting a couple of fields and they all happen to be
>in the index you are using, the DBMS can get away with only reading the
>index and not the physical record, resulting in one less disk access.
>
>- By limiting the columns you ask for to the ones you need, you can save a
>little bit on network traffic.

Is there a drawback to using 'select *' if you _do_ need all the columns,
as opposed to explicitely listing all of them?


>On Thu, 12 October 2000, "Ashish" wrote:
> >    I remember some time back there was some mention about not using
'select
> > *' in a statement but using the exact columns. Went through the
archives,
> > article ? I need to enforce this and have to do some hard convincing,
and
> > some solid reason which I can quote.

--- -- -
Seb Barre - sebastien at oven.com
OVEN Digital Toronto
Work: 416-595-9750 x 222
Home: 416-254-5078
http://www.oven.com/




--__--__--

_______________________________________________
Help: http://lists.evolt.org/mailman/listinfo/thelist

Archives: http://lists.evolt.org

End of thelist Digest





More information about the thelist mailing list