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.
By Ndoba 1 answered Oct 10, 2014 at 02:54 PM