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: SQL Tunning

Re: SQL Tunning

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 24 Jan 2001 21:12:51 -0800
Message-ID: <3A6FB5D2.FD584499@exesolutions.com> 






> we're starting tunning for the provider application and we've a doubt.

> When a "select count(*) " sentence generally returns zero, how will be

> the performance over a large table?




Could you please repeat your question with a bit more detail. I am having
a hard time understanding what you are asking.



Also, generally select count(1) is faster than select count(*).



Daniel A. Morgan
Received on Wed Jan 24 2001 - 23:12:51 CST












Original text of this message













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