Re: Table Stats

On Thu, 2003-07-31 at 23:23, Dennis Gearon wrote:
> 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.

It'll give him what he wants, but not quickly, if it's a 10/20/etc
M row table.

One hack is:
CREATE TABLE T_CARDINALITY (
RELATION_NAME CHAR(31) PRIMARY KEY,
CARDINALITY BIGINT );

Then put ON INSERT/ON DELETE triggers on each table you want to
track that increment/decrement T_CARDINALITY.CARDINALITY at the
appropriate moment.

> Jeff Davidson wrote:
>
> > Hi!
> >
> > Is there any quick way to determine how many rows exist in a given table?

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA |
| |
| "I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables!" |
| unknown |
+-----------------------------------------------------------------+