From: Jeremy Day (jeremy.day_at_[hidden])
Date: 2006-10-06 12:05:15
On 10/6/06, james.jones_at_[hidden] <james.jones_at_[hidden]>
wrote:
>
> Surely you mean "... NOT using select *..."? I've always considered it a
> best practice not to use select * in any production code. Is there another
> perspective on this?
It is my understanding that "select *" is generally less efficient than
specifying the fields to select. Not to mention that if you are relying on
select * to return fields in a specific order, and that order changes,
you're in for some hard to find bugs.
Jeremy