The question was quick indeed, but the answer must be slow...
Use the 'show actual execution plan' in SQL Management Studio, to analyze a particular query. The execution plan will depend, among other things, on:
- How many records are there on the table? For a tiny table with a few thousand records indexes will not be used.
- Using statistics, which percentage of the records in the table are expected to return from your query? For above 15% of the records, indexes will seldom if ever be used.
- More...
Hope this helps,
Pablo.