6 Oct
2006
6 Oct
'06
4:05 p.m.
On 10/6/06, james.jones@firstinvestors.com <james.jones@firstinvestors.com> 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