1

I've come across a situation where i want to select almost all columns of the table except few. So which is better to use: SELECT * or selecting particular columns ? Can anyone brief this with respect to space and time efficiency.

nbbk
  • 1,102
  • 2
  • 14
  • 32
  • How many rows do you have in your table? How many columns? What indexes? What table? – Basile Starynkevitch Feb 07 '13 at 19:19
  • This horse has been beat too much. – Kermit Feb 07 '13 at 19:22
  • I've heard that `SELECT *` is faster than `SELECT col1,col2,...colN` as well - even when selecting all columns in both examples. I personally, only specify the columns I need, though - if nothing else, to conserve the bandwidth of dealing with more data than I need. – crush Feb 07 '13 at 19:23
  • I'm still in the developing stage testin with my own db... no of cols is 4, probably the rows may grow upto 10000. No exact idea – nbbk Feb 07 '13 at 19:25

0 Answers0