No straight answer, ha?

Thanks,

Michael


----- Original Message ----- 
From: "Pete Freitag" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 5:58 PM
Subject: RE: COUNT(*)


> I think this depends on the DBMS that you are using.  In SQL Server 
I 
> think
> COUNT(field) is faster, and in Access COUNT(*) is faster.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to