:. To be honest I need counting only once per session. Even though I'd like
to count more times. The problem is that in large tables with a million and
a half of records it takes precious time. I was just wondering whether
exists another way of getting the same information but quicker.

:. I think I will implement Ann's solutions only to see if it works in my
case.

Many thanks to all of you.

Roque

"Svein Erling Tysvaer" <svein.erling.tysvaer@...> wrote in
message news:5.1.0.14.0.20030527083930.031a8db0@[158.36.132.22]...

> One question that is natural to ask is why you want this count. Sometimes
> it is of course neccessary, but in general people coming from a desktop
> database background tend to desire row counts excessively. Tell us the
> background and you may get more helpful answers to alternatives to

counting

> all rows.
>
> Set
>