3 ms·
The query speed may be the same (I don't know if this is true or not), but fetching the data from disk and returning it over a network will certainly be slower,
by chrisb 15y ago
The query speed may be the same (I don't know if this is true or not), but fetching the data from disk and returning it over a network will certainly be slower, especially if the unnecessary columns contain large strings or blobs.