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 -> Perf Tuning

Perf Tuning

From: Alex Ivascu <alex_at_ivascu.com>
Date: Mon, 13 May 2002 23:14:29 GMT
Message-ID: <pNXD8.73018$071.26290917@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???



"In Oracle, the execution plan for the 'select count(*)' and 'select
count(primary key)' is identical, which means that there is no difference
between two queries in terms of performance..."



Any links or comments are more than welcomed!!! I need to figure this
out..... TIA!



Alex Ivascu
Received on Mon May 13 2002 - 18:14:29 CDT












Original text of this message













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