Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Are the two SQLs equivalent?
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.
In Oracle versions 8 or lower, 'SELECT 1 ...' was also recommended ... apparently, the server allocated memory for "*" columns or some such nonsense, requiring it to query the table definition, whereas with "SELECT 1" (or some other constant such as 'A') the engine didn't need to touch the table at all.
-- Bob Hairgrove NoSpamPlease_at_Home.comReceived on Tue Jun 07 2005 - 15:57:11 CDT