count(*)

Morten.

remember that count may do a full table scan, so will read every data block up to the high water mark - regardless of whether the data block is empty or not. This means that if your table_b has had a lot of deletions don on it, then it may have a number of empty blocks and although the row count is the same, the tables are not identical.

Check out http://www.ixora.com.au for details on some experimentation with count(*) and count(column) and you will see that it is probably running as quick as it can.

Cheers,
Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------

-----Original Message-----

From: Morten Primdahl [mailto:morten_at_caput.com] Posted At: Monday, April 08, 2002 9:06 AM Posted To: server
Conversation: count(*)
Subject: count(*)

Hi. What affects the execution speed of count(*): <SNIP> Received on Mon Apr 08 2002 - 04:28:35 CDT