Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Are the two SQLs equivalent?
Bob Hairgrove wrote:
> On Tue, 07 Jun 2005 19:53:01 GMT, Lee Fesperman
> <firstsql_at_ix.netcom.com> wrote:
>
>
>>Lastly, when using EXISTS the preferred form for the SELECT clause is 'SELECT *'. Unless >>the optimizer is crazy it should make no difference and is clearer.
Same myth source as select count(1) is faster than select count(*), I presume. Recommended by whom? Backed by what proof?
-- Regards, Frank van BortelReceived on Wed Jun 08 2005 - 13:30:39 CDT