Does table columns increase select statement execution time

Posted by paokg4 on Stack Overflow See other posts from Stack Overflow or by paokg4
Published on 2012-09-17T15:27:55Z Indexed on 2012/09/17 15:37 UTC
Read the original article Hit count: 184

Filed under:
|
|

I have 2 tables, same structure, same rows, same data but the first has more columns (fields).

For example:

I select the same 3 fields from both of them (SELECT a,b,c FROM mytable1 and then SELECT a,b,c FROM mytable2)

I've tried to run those queries on 100,000 records (for each table) but at the end I got the same execution time (0.0006 sec) Do you know if the number of the columns (and in the end the size of the one table is bigger than the other) has to do something with the query execution time?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about Performance