Since your primary key is used, maybe you should consider adding an index on PostedZpdi field only.
You may also check 'key_buffer_size' value (show variables like 'key%'). Since your primary key is more than 200 MB big, allocating a "big" key buffer (> 256MB) may help.
Joseph Bueno
Nathan Cassano wrote:
mysql> explain select distinct AccountLevelId from PostedZpdi; +------------+-------+---------------+---------+---------+------+---------+- ------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +------------+-------+---------------+---------+---------+------+---------+- ------------+ | PostedZpdi | index | NULL | PRIMARY | 60 | NULL | 3447290 | Using index | +------------+-------+---------------+---------+---------+------+---------+- ------------+ 1 row in set (0.01 sec)
Hi,
What do you get when you do an EXPLAIN of your query ?
-- Joseph Bueno
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
