Let's say I have a table named tablex:
ID,col1,col2,col3,col4,col5,col6.
Which of the following codes is FASTER, given that col4 is not required during processing?
code 1 - SELECT * FROM tablex
code 2 - SELECT ID,col1,col2,col3,col5,col6 FROM tablex
(note col4 is absent in code 2, since it is not needed, all col is text from 80 varchars, ID is only int, auto-increment)
Thank!
source
share