damn it John 😛 i was just about to reply. lol
Totally agree with what John has said. if you new to sql. SQL will choose the best index's to use. It is unusual to use a index hint to force a query to use that index. Normally if you are not seeing the index appear in the execution plan for that query. it should make you think hard about how your query is written.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]