statements: SELECT * (is evil)

[grooverdan]

Select * returns the entire row. In many statements here the entire row isn't needed. By requesting more data than is needed, optimizations where the data can be returned by the index or less data can be returned is lost.

The existing statements should be validated to see which rows are actually needed.