Select count(*)

In <21fkdvINNi2i@emory.mathcs.emory.edu> naomi@qip.anasazi.com writes: >The problem I have with setting ISOLATION is that it affects the entire >database, and sometimes I only want a particular table. A silly thought >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(*). I assume that update statistics has been run recently also? Or does update statistics have no effect on nrows?... -- Clay Irving New York, NY "Everything should be made as simple as possible, but not simpler." Einstein