Which is quicker - SELECT * or SELECT field1, field2...

[Ruslan Zasukhin]

On 12/14/05 8:24 PM, "Dave Addey" <listmail1 at dsl.pipex.com> wrote:

> Another question:
> 
> If I only need half of the fields in a table, which should be quicker ­
> SELECT * or SELECT fieldname1, fieldname2, [...], fieldnameN?
> 
> I figure that * has to select more, but doesn¹t have to do any working out
> of what to select.  Does this make it quicker?
> 
> How about SELECT ** vs SELECT fieldname1, fieldname2, [...], fieldnameN?

Always good idea select fields explicitly


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]