I would like to reduce the access to these tables: fact_input_output, dim_org_v, rap_combo

Ndoba 2014-10-10 15:01:03

Hey Aaron.

I got rid of one key lookup. I modified the query a little bit.
I still have one key lookup despite the fact i've added the columns org_v_id and and type_demande_id in the IX_ndobs_demande_id_soustache_id index.
But anyway, it's better now.

Thanks a lot.

SQLkiwi 2014-10-14 08:49:38
>*I still have one key lookup despite the fact i've added the columns org_v_id and and type_demande_id…*

The Key Lookup is there because the nonclustered index does not contain the evenement_id column.

The RID Lookup is there because the nonclustered index does not contain the id column.