performance tuning in sql MySQL

AS AN AMAZON ASSOCIATE I EARN FROM QUALIFYING PURCHASES.