I would like to reduce the access to these tables: fact_input_output, dim_org_v, rap_combo
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.
I attached the plan.
Thanks a lot.