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: [EMAIL PROTECTED] | | Jefferson, LA USA | | | | "I'm not a vegetarian because I love animals, I'm a vegetarian | | because I hate vegetables!" | | unknown | +-----------------------------------------------------------------+ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings