Hi,
Do count(1) - I read this is the fastest a while ago.
i.e. select count(1) from X where col='val' etc.
Jonathan
>I believe it is a known problem (feature?) with Oracle that COUNT(*)
>has to scan the whole table (even *deleted* rows), but if you just
>choose a column name (probably should be an indexed column) and do
>COUNT(colname) you'll get a drastic improvement in performance. I
>haven't tested this but I have heard about it before. Good luck.
>
>-Tom
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
