It will be much more helpful, if you provide an Actual Execution Plan (in xml) for this slow query. If this is not a slow query by it self, but you think it is the slow part of more complex query, than it would be nice if you provide the actual query plan for all the complex query (including slow part), and a plan for it, without slow part (when you comment slow part, for example).