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
