From: Daevid Vincent
Date: April 18 2003 9:23pm
Subject: RE: How do I optimize SELECT COUNT(*) WHERE queries?
List-Archive: http://lists.mysql.com/mysql/137660
Message-Id: <005f01c305f0$d5601680$a50aa8c0@Locutus>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Not sure if it helps, but I was always under the impresssion to use COUNT(1)
instead of COUNT(*)