Does table columns increase select statement execution time
- by paokg4
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?