thank you for your response. Here is the thing, I don't know how to write stored procedures and call them within PHP. also yes some of the queries can be...

thank you for the quick response.

So regarding the indexes. The tables that get accessed the most on my server, I right click on it, went to All Tasks, Manage...