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
- OT: COUNT(*) Michael Lugassy
- RE: COUNT(*) Evan Lavidor
- RE: COUNT(*) Philip Arnold - ASP
- Re: COUNT(*) I think I think ;-) Pete Freitag
- Re: COUNT(*) I think I think ;-) Michael Lugassy
- RE: COUNT(*) Philip Arnold - ASP

