Geek asks and answers

Does the order of the columns in the select expression show the query speed?

For example, I have a database like this:

id | fname | lname | sex | age | tel | cell | address

If I execute select cell, fname, address, sexinstead of execution select fname, sex, cell, address, will this affect the query speed in large tables?

I checked phpmyadmin quickly and seemed to be taking the same time, but I wanted to double check.

Thank.

+3
source share
3 answers

It will not make any difference.

However, omitting the columns from the sentence SELECT, it will work faster because it will send less data over the network.

+8
source

This will not affect the smallest bit.

+1
source

Another thing that will make it work faster is creating indexes in the fields that you will look for the most.

+1
source

More articles:


All Articles