[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