I have assigned Indexes for my tables. Is there any way to identify the performance of my query? Thank you
EDIT
Here i am attaching my test servers EXPLAIN result. In test server there are only few rows but in live server there are crores of records and it takes 10 to 15 minutes to execute query. if its not visible here i am giving url for this image
http://i45.tinypic.com/n6t8cx.jpg
See Question&Answers more detail:os