Hi,
If it helps any, I reported of the similar findings (slow) on the list about
18 months ago. We too have seen poor performance. Microsoft Jet database
("Access") engine is hundreds of time faster on Count(keyfield) and count(*)
operations. This is only with 3,000,000 small records.
There must be some way that these other databases are doing it more
efficiently.
Stephen
-----Original Message-----
From: ajit_cus [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 24, 2002 9:45 PM
To: [EMAIL PROTECTED]
Subject: general note on the performance of count(*) queries
Hi,
Select Count(*) from tablename queries seem to work very slowly in SAPDB.I
tried the query on identical schema/indexes in both Oracle and SAPDB and
ORACLE takes around a sec, SAPDB takes around 25 secs. There seems to be
some cacheing going on as the query executes much faster if I execute it
immediately again.(Note: I used SQL Studio for the test)
Of course one logical reason for the difference in speed is that oracle
uses any column with an index on it to optimize count(*).I get a similar
performance gain in SAPDB if I use --> select count(SomeIndexedColumn) from
sametablename(which gives the same result anyway). Is there any was I can
get SAPDB to automatically optimize select count(*) queries? Regards, Ajit
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
