title: Mysql Index is not working
body: <p>Can anyone please tell me why mysql is not using 'playerLead_status_INDEX' index?</p>
  
  <pre><code>CREATE TABLE `bcs_player_lead`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `first_name` varchar(100) DEFAULT NULL,
    `last_name` varchar(100) DEFAULT NULL,
    `email_id` varchar(100) DEFAULT NULL,
    `city` varchar(100) DEFAULT NULL,
    `state` varchar(100) DEFAULT NULL,
    `country` varchar(100) DEFAULT NULL,
    `created` datetime DEFAULT NULL,
    `status` int(11) DEFAULT NULL COMMENT '1-New,2-invitation send',
    PRIMARY KEY (`id`),
    KEY `playerLead_status_INDEX` (`status`)
  ) ENGINE=InnoDB AUTO_INCREMENT=510 DEFAULT CHARSET=latin1;
  </code></pre>
  
  <blockquote>
    <p>EXPLAIN SELECT email_id,id,NULL,first_name,last_name,NULL,state,city,NULL,(2) as type 
    FROM bcs_player_lead WHERE status='1'</p>
    
    <p>id|select_type|table           |type|possible_keys         |key   |key_len |ref   |rows |Extra<br>
      1 |SIMPLE     |bcs_player_lead |ALL |playerLead_status_INDEX|{null}|{null}|{null}| 458 |Using where</p>
  </blockquote>
  
  <p>bcs_player_lead have two keys -</p>
  
  <ol>
  <li>PRIMARY on ID</li>
  <li>playerLead_status_INDEX on status</li>
  </ol>
  
  <p>Thanks in advance!</p>