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.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+