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]
