Re: number of registers of a table

On Tue, Jun 18, 2002 at 10:41:37AM -0300, Fabricio Boppre wrote:
> hi,
>
> i would like to know if there is some command that works like "select count"
> but gives me faster results than "select count" does for the ammount of
> registers of a table that is updated all the time.

Not really, but if it's updated all the time, why not make a
statistics table that will give you a rough idea? You could have a
job update it, say, every half hour.

A

--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110