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

[Dave Addey]

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?

V4RB 2.0.5, RB 5.5.5, Mac OS 10.4.3, Mach-O compile, local database only.

Thanks for all the help ­ I¹m nearly there!

Dave.