How can I count rows fast ?
From: Guido Derwand <derwand_at_sap-ag.de>
Date: Fri, 10 Jun 1994 10:08:49 GMT
Message-ID: <derwand.771242929_at_sapwdf>
Date: Fri, 10 Jun 1994 10:08:49 GMT
Message-ID: <derwand.771242929_at_sapwdf>
Is there a faster method to count rows in a table than using SQL 'SELECT COUNT(*)' in Oracle V. 6 or 7 ? I've heard from some expirience with using 'SELECT COUNT(<index>)' to be faster, but I couldn't reproduce this (there seems to be no difference).
Is there a chance to make it faster with a b-tree analysis ?
How ever, I'm interested in every possibility (just mail it to me or post it in this group).
Guido Derwand (email: derwand_at_sap-ag.de) Received on Fri Jun 10 1994 - 12:08:49 CEST