In the last episode (Sep 07), [EMAIL PROTECTED] said:
> Hi Dan,
>
> Thanks for yur response. Does it makes sense to create an index on a
> primary key ..as that is my smallest field ?
It might, because in an InnoDB table, your primary index also holds
your row data. So it's actually your largest index. A full scan of a
secondary index on your primary key may very well run faster than a
scan of the primary index itself, for the purposes of "SELECT
COUNT(*)". Best way to find out is to try it :)
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
