3 ms·
It depends. If there are a lot of columns and you're only interested in a handful, and there's an index that contains all those columns, it should be much cheap
by barrkel 16y ago
It depends. If there are a lot of columns and you're only interested in a handful, and there's an index that contains all those columns, it should be much cheaper just to select the interesting columns, as all the data needed can be retrieved from the index. Asymptotically, the size ratio between the columns selected and the columns in the table gives the speedup.