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

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.

avatar image By Ndoba 1 asked Oct 10, 2014 at 03:01 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

1 answer: sort voted first

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.

avatar image By SQLkiwi ♦ 6.6k answered Oct 14, 2014 at 08:49 AM
more ▼
(comments are locked)
10|10000 characters needed characters left
Your answer
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x641
x455
x117
x24
x18

asked: Oct 10, 2014 at 03:01 PM

Seen: 310 times

Last Updated: Oct 14, 2014 at 08:49 AM