my question is w/ sql statements... if i only need say 1 field from a table should i use
"select X FROM table"
"select * from table" as efficient
i know common sense is pointing me to the first example but it never hurts to ask. also what happens if i need like 4 or 5 fields out of 10... would that be the same situation as if it were just 1 like the example above?