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

Home -> Community -> Usenet -> c.d.o.misc -> count(*) vs count(columnX): Which one is better?

count(*) vs count(columnX): Which one is better?

From: Robert Chung <robertch_at_mindspring.com>
Date: Fri, 23 Oct 1998 00:51:10 GMT
Message-ID: <362fd1ec.6534135@news.mindspring.com> 






Regarding an SQL statement like this:


  SELECT count(*) FROM tableX where columnX='ABC'
and


  SELECT count(columnX) FROM tableX where columnX='ABC'



Which one is better for performance?  What if columnX has an index?
Would there be some differences in performance and efficiency?  Thank
you in advance.



Received on Thu Oct 22 1998 - 19:51:10 CDT












Original text of this message













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