> Can you send show keys from campaign_t. > I bet you can solve your problem by running analyze table.
mysql> show index from campaign_t\g +------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+---------+ | campaign_t | 0 | PRIMARY | 1 | acct_id | A | 1898 | NULL | NULL | | | campaign_t | 0 | PRIMARY | 2 | site_id | A | 5621 | NULL | NULL | | | campaign_t | 0 | PRIMARY | 3 | ref_id | A | 109627 | NULL | NULL | | | campaign_t | 0 | PRIMARY | 4 | datestamp | A | 438511 | NULL | NULL | | | campaign_t | 1 | acct_id | 1 | acct_id | A | 1898 | NULL | NULL | | | campaign_t | 1 | site_id | 1 | site_id | A | 36 | NULL | NULL | | | campaign_t | 1 | ref_id | 1 | ref_id | A | 54813 | NULL | NULL | | | campaign_t | 1 | datestamp | 1 | datestamp | A | 76 | NULL | NULL | | +------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+---------+ I have no idea how to interpret this.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]