Read your post. I copied those statements from your post word for word. Figured those were your query conditions.

Maybe something like this will work. Just splitting up your ORs into separate queries.

IF OBJECT_ID('tempdb..#Test1') IS NOT NULL

DROP TABLE #Test1

IF OBJECT_ID('tempdb..#Test2') IS NOT NULL

...

I found this article on Index usage interesting. By Kimberly Tripp. Talks about Tipping Points.

http://www.sqlskills.com/blogs/kimberly/category/the-tipping-point/