How to optimize the index scan

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?

Hi,

Sorry, I am new.

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

Hi Yucer, you can use Plan Explorer : http://sqlsentry.net/plan-explorer