\[quote\] Possible Duplicate:
Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc. \[/quote\]Is it bad practice to use \[code\]Select *\[/code\] ?I was going through some old code and saw some 'SELECT *' statements. My previous coworker had told me Select * was bad practice, but I couldn't really see the reason why (unless of course I only needed to return a few fields). But for full 'detail retrieves' (Get by Id type queries) Select * seems right.
Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc. \[/quote\]Is it bad practice to use \[code\]Select *\[/code\] ?I was going through some old code and saw some 'SELECT *' statements. My previous coworker had told me Select * was bad practice, but I couldn't really see the reason why (unless of course I only needed to return a few fields). But for full 'detail retrieves' (Get by Id type queries) Select * seems right.