[thelist] Select *

[Seb Barre]

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/