SELECT COUNT(DISTINCT( `cycle_flag`)) as numCycles FROM `crmReserve01`.`tblCDR` WHERE `cycle_flag` LIKE '___20__C_'
and when I do an EXPLAIN +--------+-------+---------------+------------+---------+------+-------- -+--------------------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +--------+-------+---------------+------------+---------+------+-------- -+--------------------------+ | tblCDR | index | NULL | cycle_flag | 11 | NULL | 3518750 | Using where; Using index | +--------+-------+---------------+------------+---------+------+-------- -+--------------------------+ I have killed these queries, but the processlist shows | 229 | jblanchard | feynman:2017 | NULL | Killed | 393107 | Sending data | SELECT COUNT(DISTINCT( `cycle_flag`)) as numCycles FROM `crmReserve01`.`tblCDR` WHERE `cycle_flag` LIKE '___20__C_' | | 292 | jblanchard | feynman:2210 | NULL | Killed | 306673 | Sending data | SELECT COUNT(DISTINCT( `cycle_flag`)) as numCycles FROM `crmReserve01`.`tblCDR` WHERE `cycle_flag` LIKE '___20__C_' note the time! Have we done something with this query we shouldn't do? TIA! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
