Budd,

I think with such a simple query performance would be best improved with good use of indexing. If possible create a clustered index on the column in your WHERE clause, or if that is not possible then a non-clustered index with the other columns in your SELECT clause as included columns.

Hope that helps,

Ash