Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: count(*)
That's certainly a possibility, but it still won't scale. Regardless of
whether PQ is used, Oracle will need to do x consistent gets. As the
tables grow larger, x will increase. Regardless of whether PQ is used,
that number of buffer gets that are required will not change, and the
total load on the system will not change (except to increase as the
tables grow larger). PQ may reduce elapsed time, but will do nothing
for the total resources consumed.
-Mark
On Thu, 2002-09-19 at 16:18, Suri, Deepak wrote:
> I have in the past used parallel hints to speed up a count(*) kind of full
> table scan query.
>
> thanx
> deepak
>
> -----Original Message-----
> [mailto:Rishi.Jain_at_VerizonWireless.com]
> Sent: Thursday, September 19, 2002 2:28 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Gurus,
>
> In one of our insert intensive application we are inserting around 3-4
> million rows / hour. Also this app needs to do a count(*) of the tables
> every 10 minutes for verifying some application based logic. This is really
> killing us and it takes a lot of time.
>
> Can you please guide me to a direction ( built in functions or something
> similar).
>
> Actually this app is being ported from Informix. Informix can somehow keep a
> trak of the count(*) of a table in its header somewhere.
>
> And yes I have tries count(1) , count(indexed_column) etc.
>
>
> Thanks In Advance.
>
> R.h
-- -- Mark J. Bobak Oracle DBA mark_at_bobak.net "It is not enough to have a good mind. The main thing is to use it well." -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: mark_at_bobak.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Sep 19 2002 - 16:33:33 CDT
![]() |
![]() |