>Agreed. But the reading of indexes are records too (though to be honest, I wasn't implying that ;)

Index records are usually much smaller than the actual records.

>But seriously, it wasn't (originally) about having an index, but a Set Filter.

The original question was looking for a possible alternative to SET FILTER.

>
< SNIP >

>BTW, has the parameterized view really to do with it ?

Again, going back to the original question, he asked if a view would be faster. I threw in parameterized for free, but also mentioned query (referring to a SELECT) statement.

I think the view would give better overall response, and I think there would be quicker reponse navigating between records. The performance hit when the view loads should be minimal, especially if the teacher is retrieving 25-50 records out of a table of only 9,000 students.