>From this explain plan it appears a full table scan will be done. What is the cardinality of this index?
-----Original Message----- From: [EMAIL PROTECTED] To: Victor Pendleton Cc: '[EMAIL PROTECTED] ' Sent: 5/18/04 1:54 PM Subject: Re: Simple table, 1.7 million rows, very slow SELECTs On Tue 18 May 02004 at 01:47:25PM -0500, Victor Pendleton wrote: > What is the cardinality of the `junk` column? What does an EXPLAIN Plan > show? > mysql> explain select junk from data where junk='xxxxxxxxxx'; +-------------+-------+---------------+---------+---------+------+------ ---+--------------------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-------------+-------+---------------+---------+---------+------+------ ---+--------------------------+ | junk | index | PRIMARY | PRIMARY | 10 | NULL | 1797425 | Using where; Using index | +-------------+-------+---------------+---------+---------+------+------ ---+--------------------------+ 1 row in set (0.00 sec) -- Jacob Elder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]