>I have, so far without success, tried using INDEX(MyIndex1,MyIndex2)
>as hints in a query, and all I get for my trouble is a syntax error.
>
>Looking in help did not do the trick either, so I guess it's up to you guys.
>
As you aware, you've to use hints only as the last resort. Usualy Sql Server does pretty good job in building optimal plan for your query. Here's the sample code tested under SQL 2000.
SELECT *
FROM test1 WITH (INDEX(pk_test1, ix_test1))
WHERE id >= 2
--sb--