Mysql line selection star or name optimization

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!

+3
source share
3 answers

, . , , . col4 BLOB, , , ( *) , "" .

+1

( ) , col4 .

, , , .

, ( , ).

+1

2 , ,

-2

Source: https://habr.com/ru/post/1781990/


All Articles