I've always assumed that any SQL command where you give it a
specified field
or fields, rather than (*) is faster. I haven't done any testing
with this
particular statement, though.
Evan
> -----Original Message-----
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 18, 2001 11:38 AM
> To: CF-Talk
> Subject: OT: COUNT(*)
>
>
> Which is faster?
> COUNT(*) or COUNT(fileID)
>
> assuming fileID is a regular INT, that is also my primary key
>
> Thanks,
>
> Michael
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
