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]