Performance on Large volume heavy read load data on SQL 2008
===

i have a performance issue.

we have a table which goes in to a couple of million records. and we are serving up a web page which hits this table 100's of times every second (a select) the query is covered by a non-clustered index (wrapped in an SP as well)

my question is for a specific scenario we want to improve the performance, would it be wise for us to create a view which would always yield 300 rows for this scenario and index the view and query the view, or will it make no difference if i query the existing 2M plus table with the covered query?

thanks in advance!

