The Evil That is "Select *"
It also limits SQL's ability to find a proper index to use, hence hindering performance. I wasn't aware of this aspect until a SQL consultant made mention of it. Unfortunately we haven't adopted the policy of dropping the *.
It also limits SQL's ability to find a proper index to use, hence hindering performance. I wasn't aware of this aspect until a SQL consultant made mention of it. Unfortunately we haven't adopted the policy of dropping the *.