How to optimize the index scan

Carlos Messias 2014-03-13 18:46:34

Aaron Bertrand 2014-03-13 18:53:28
Hi Carlos, something is always going to be the most expensive operation in a plan. Your upload did not include runtime metrics, such as duration – how long does this query currently take?
yucer 2014-03-14 11:00:12
Hi,

Sorry, I am new.

Could you tell me which utility opens and produces .queryanalysis files ?

Aaron Bertrand 2014-03-15 13:33:03
Hi Yucer, you can use Plan Explorer : http://sqlsentry.net/plan-explorer