EMENOH

I was recently asked about optimizing an existing Database and existing web application SQL queries. I had some answers but afterwards wanted to make sure I was up-to-date. Here is what I had to say and what I found out.