ok, thanks for reply!

Thanks

Thanks for the reply :), we have a report setup to check but was wondering if it could be done without any 'extra' work.

What would be the best way of evaluating the performance of an inner query?

say you have something like

SELECT Key, sum() , sum() max()

into #table

from

(select key, case(), case() case()

union

select...

Thanks for the reply.

Thanks for the reply.

So you don't think they are of much use?

Scenario I was looking at was query A takes a long time to run to build a...

Grant Fritchey (3/21/2014)

---

roblew 15918 (3/21/2014)

---

GilaMonster (3/21/2014)

---

EXECUTE <procedure name> WITH RECOMPILE will generate a new plan just for this execution, the generated plan won't be cached and the cached plan won't...

Thanks, and adding...

Great thanks.

What would the best way be to test the performance/improvement if any of using a clustered index view?

With he proc I can run the code, use the execution plan,...