Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Perf Tuning

Re: Perf Tuning

From: Sergey M <msu_at_pronto.msk.ru>
Date: Tue, 14 May 2002 12:32:42 -0700
Message-ID: <abqi6p$2orf$1@serv2.vsi.ru> 






"Alex Ivascu" <alex_at_ivascu.com> wrote in message
news:pNXD8.73018$071.26290917_at_typhoon1.we.ipsvc.net...


> Is this true?  I always thought that using select count(indexedcolumn)

from


> table is faster than select count(*) from table... am I wrong???




Wrong! And if "indexedcolumn" is NULL. It is mean what this didn't index,
so I think Query "select count(1) from table" is faster.



Sergey M.
Received on Tue May 14 2002 - 14:32:42 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US