Re: <No Subject Supplied>

Mailer: Elm [revision: 70.30] Quoting Naomi: > though. To get the number of rows in a table, sometimes I : > > SELECT nrows > FROM systables > WHERE tabname = "table_name";> > Its much faster than count(*). > Yes, but nrows is set by update statistics. If you haven't done that lately you get a wrong value. j. _____________________________________________________________________________ Jack Parker - Contractor | Hewlett Packard, BSMC Boise, Idaho, USA| If you keep staring at it like that, jparker@hpbs2561.boi.hp.com | your nose is going to grow (208) 396-5388 (W) (208) 384-1623 (H) | into the bark. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________