I got a message from Hostgator about my account being suspended because of the load it put on their servers. This is about the fifth time this has happened. I am on a shared server.
And they said it could be resolved by simply adding new indexes to the database or optimizing the database using other techniques. I have been using SQL queries and the "optimize" option in phpMyAdmin to optimize my database but that hasn't helped.
I have also installed Super Cache as recommended by them but this hasn't helped either.
Now, I want to try adding indexes to the database. How do I do this? Does anybody know how to do this please? It's urgent.