To be honest it is usually what you mentioned and if any obvious indexes were missed on the table. After that it is generally a more formal investigation. Rece

To be honest it is usually what you mentioned and if any obvious indexes were missed on the table. After that it is generally a more formal investigation. Recently a coworker massively (like more than 100x) improved a vendor's product when he found, using an automated tool, that there was a huge area for improvement in the generation of links on a particular page. You might have seen syntax like reverse('app1.view.view1') in Django or Html.ActionLink(...) In MVC. Well this app had to do something similar, but at the scale it was now doing it, its analogous method was far too slow and was really taking up the most time on the page.