Posted by NC on 05/22/06 19:35

strawberry wrote:
>
> You miss my point. I DO want ALL the columns. It's just that (from what
> I've read) the query is supposed to work faster if ALL the columns are
> individually named in the query.
>
> So, if that's true - and with that fact in mind - is the code I've
> written the simplest way of going about this or is there (as I'm sure
> there must be) a better way?

There is. Use SELECT *. Even if SELECT * is somewhat slower than
SELECT [fields], it's still one query. In your solution, there are
two. Since there is a fixed per-query overhead, your solution is
probably worse than the problem you are trying to solve...

Cheers,
NC

[Back to original message]