MySQL execute plan behaves different in Master and Slave

[Jagadeesh Chinnathambi]

I have one MySQL query, and that query is using an index on the master but not using an index on the slave.

The query is as simple as SELECT * FROM table1 JOIN table2 ON table1.primary_id = table2.fk_id with simple where condition.

We checked the structure, indexes, global variables, data, and everything else. Everything is in sync.

I am expecting the query to use the index on the slave.