>>>Then perhaps you should reconsider Naomis suggestion of a filtered index if those selects happen often.
>>>Filtered-Indexed Selects should both be similary fast (as the index materializes the set)
>>>and still a little bit faster than a normal index on a smallint column
>>>and all much faster than unindexed ones
>>>with slight speed advantage to the smallint in case of updating/refshuffling the values.
>>>
>>>regards
>>>
>>>thomas
>>
>>Thank you for your suggestion. And I will keep it in mind if or ever my app will be designed for SQL 2008 only.
>
>sorry, missed the version ;-)
Not a problem. Sooner or later MSFT will drop support for SQL 2005 (just like they did for VFP <g>) and we will all be using SQL Server 2008.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham