JblakTSql (2/13/2013)

---

So I have this odd issue that I can't figure out how to solve. I have a poorly written view which runs slowly but works (returns data in ~ 8 sec). Select * from view1 returns:

Action Name Server
add item1 server1
add item2 server1
update item3 server2


I know i am violating a common rule but have a good reason where I am nesting this view inside of another view which filters the results to an action. In this case my view is called view2 with code Select * from view1 where action = 'update'. This runs in ~ 7 secs.

Now here is the problem. When I run the following: Select * From View2, it returns data in roughly ~7 sec. When I run Select * from View2 Where Server = 'Server2', returns data in roughly ~ 7sec, but when I run Select * from View2 where Server = 'Server1', this returns no rows (which is correct) but take over 1 min to return. Any idea why this would happen or how to troubleshoot this?

Any idea why this would happen or how to troubleshoot this?

opc.three (2/14/2013)

---

No way to tell from here. Please post the Actual Execution Plans for all three queries.

JblakTSql (2/14/2013)

---

no, I am not able to create indexes for this data. It has duplicates in it.