Temporary Indexes and Embedded SQL

[Marco]

Hi Peter

Can you even be sure SQL will take that index processing the query?

You can use index hints like:

select top 10 * from Contact WITH (INDEX(Contact002))

But I must say that I don't use that much. I'm expecting that the CK would though... As it skips the Query Optimiser and thus in theory is faster.

Cheers
Marco