Re: Table Stats

It will only be at a given point in time, since datasbases are by design, realtime/concurrent applications.

do:

SELECT COUNT(*) FROM table_name;

Should give you what you want.

Jeff Davidson wrote:

> Hi!
>
> Is there any quick way to determine how many rows exist in a given table?
>
> Thanks!
> ---------------------------------------------
> Jeff Davidson
> Panoptic Pictures
> 6888 Alta Loma Terrace
> Los Angeles, CA 90068
> (310) 395-9300
> (310) 395-9116 fax
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>