Re: Speed of SQL Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Uri Dimant (urid_at_iscar.co.il)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 11:24:53 +0200

Simon
A second one. It is also a good practice to not use * with SELECT clause if
you really don't need all columns out.

"Simon Jefferies" <simon@cooltoolsonline.co.uk> wrote in message
news:erUk2FzYEHA.2016@TK2MSFTNGP09.phx.gbl...
> Hello,
>
> Which of the following would be quicker?
>
> SELECT * FROM TABLE
> or SELECT Field1, Field2, Field3, Field4 FROM TABLE
>
> Thanks In Advance
> Simon
>
>

Relevant Pages

  • Re: Find oldest warranty ExpDate(s) for each customer
    ... There is no way I can debate the philosophical aspects of structured query ... practice, practice, practice (warning: ... to write a SELECT query with a WHERE clause, ... I you do find any short cuts to a fuller understanding of how SQL ...
    (microsoft.public.access.queries)
  • Re: LEFT JOIN on very large tables
    ... Use the where clause for pagination, you'll find your system responds a ... lot quicker;-) ... Prev by Date: ...
    (comp.lang.php)
  • Re: WOTT - Reactions
    ... I have a suspicion that it does, but the difference is slight compared to all the other factors that make up your *effective* reaction time. ... I know that comes with practice, because if I don't play with the big boys it always takes me a while to wind up my pace, and I know for certain that if I had the chance for regular practice with those guys I'd be able to handle the quicker pace much more easily. ...
    (rec.martial-arts)
  • Re: How to obtain SS7 pointcode?
    ... > Pointcodes typically take 6 weeks to get from ofcom. ... In practice, over the last month or so they've been ... doing it much quicker. ...
    (uk.telecom)
  • Re: What is the difference between :foo and "foo" ?
    ... The point is that symbols support quicker lookup by their nature. ... Whether they are quicker in practice will depend on the ...
    (comp.lang.ruby)