Hi,
I've
read so many suggestions for making this count(*) quicker but we are all
assuming that it is needed and has a purpose in the first place - which may or
may not be the case. Obviously the quickest way to do the count(*) is to
NOT do it in the first place.
I'd
still like to know the purpose of the count(*) and what verification it is
performing? And also, why are there so many rows being inserted into the
table.
Cheers,
Craig.
Craig.
-----Original Message-----
From: Craig Munday [mailto:[EMAIL PROTECTED]]
Sent: Friday, 20 September 2002 10:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: count(*)Hi,
I am not sure if I have a solution for you, but I have a number of questions:
1) just for my interest, what type of application would need to insert 3-4 million records per hour?
2) Why does the application need to do the select count(*)....? What verification is being performed?
3) Perhaps the design of the application could change so the number of records is reduced?
Cheers,
Craig.