>>
>>When you run this query with Actual Execution plan information, what you get?
>
>I don't know what exactly to tell you. I get an Execution Plan tab displayed with some graphical stuff in it but no particular message that I can tell you. What do you need to know?
You have the best performance when you have [index seek] in Execution plan, worst is when you have [Table Scan].
Try to remove WHERE and see if you get this faster.
If yes, then should think about workaround.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.