• Select statements can absolutely affect performance.

    Can you expect improvements ? That's hard to say without know the cause of the problems. If the problems are built into the application, or coming from queries and reports that need to use production, then they will still cause problems.