• It's hard to get you something to do because there isn't enough information here. The low cahce hit ratio makes me wonder if your data is significantly diverse that you can't cache enough. If you watch the execution plans for the states, are they all the same? What is the difference in the stages?