help with this long running query

Question

help with this long running query

SSM-242970

Mr or Mrs. 500

Points: 547
More actions
September 26, 2008 at 4:30 pm

#198652

can somebody help me understand the execution plan and help me improve the query?
Thanks,
SSM
SELECT h.health_care_plan_id, h.health_care_plan_name, v1.formulary_id, v1.drug_label_assoc_detail_id, v1.drug_label_id, v1.drug_detail_id, v1.drug_label_name, v1.dict_drug_form_desc, v1.dict_drug_strength_qnty_str, v1.dict_drug_strength_unit_str, v1.dict_drug_route_desc, v1.drug_label_type_code, v1.drug_label_assoc_detail_otc_flag, v1.drug_label_on_patent_brand_id, v1.formulary_drug_label_flag, v1.formulary_drug_label_assoc_detail_flag, v1.formulary_drug_label_coverage_exclusion_flag, case when (c.drug_label_assoc_detail_id is not null) then (select dict_formulary_display_code from dict_formulary_display with (nolock) where dict_formulary_display_id=28) when (c.drug_label_assoc_detail_id is null) then v1.dict_formulary_display_code end as dict_formulary_display_code, case when (c.drug_label_assoc_detail_id is not null) then (select dict_formulary_display_desc from dict_formulary_display with (nolock) where dict_formulary_display_id=28) when (c.drug_label_assoc_detail_id is null) then v1.dict_formulary_display_desc end as dict_formulary_display_desc, case when (c.drug_label_assoc_detail_id is not null) then (select dict_formulary_display_rank_nbr from dict_formulary_display with (nolock) where dict_formulary_display_id=28) when (c.drug_label_assoc_detail_id is null) then v1.dict_formulary_display_rank_nbr end as dict_formulary_display_rank_nbr, copay_drug_label_assoc_detail_flag, copay_drug_label_flag, copay_summary_level_flag, case when (h.health_care_plan_dataload_source_code='P') then case when ((c.drug_label_assoc_detail_id is not null) or (v1.dict_formulary_display_code='X')) then NULL else copay_pharmacy_type end else null end as copay_pharmacy_type, case when (h.health_care_plan_dataload_source_code='P') then case when ((c.drug_label_assoc_detail_id is not null) or (v1.dict_formulary_display_code='X')) then NULL else copay_first_term end else null end as copay_first_term, case when (h.health_care_plan_dataload_source_code='P') then case when ((c.drug_label_assoc_detail_id is not null) or (v1.dict_formulary_display_code='X')) then NULL else copay_flat_dollar_amount end else null end as copay_flat_dollar_amount, case when (h.health_care_plan_dataload_source_code='P') then case when ((c.drug_label_assoc_detail_id is not null) or (v1.dict_formulary_display_code='X')) then NULL else copay_percent end else null end as copay_percent, case when (h.health_care_plan_dataload_source_code='P') then case when ((c.drug_label_assoc_detail_id is not null) or (v1.dict_formulary_display_code='X')) then NULL else c1.dict_copay_display_id end else v1.dict_copay_display_id end as dict_copay_display_id, case when (h.health_care_plan_dataload_source_code='P') then case when ((c.drug_label_assoc_detail_id is not null) or (v1.dict_formulary_display_code='X')) then NULL else copay_min_dollar_amount end else null end as copay_min_dollar_amount, case when (h.health_care_plan_dataload_source_code='P') then case when ((c.drug_label_assoc_detail_id is not null) or (v1.dict_formulary_display_code='X')) then NULL else copay_max_dollar_amount end else null end as copay_max_dollar_amount, case when (h.health_care_plan_dataload_source_code='P') then case when ((c.drug_label_assoc_detail_id is not null) or (v710NULLNULL1NULL3.0621272E+7NULLNULLNULL23502.48NULLNULLSELECT0NULL
|--Compute Scalar(DEFINE:([Expr1137]=If ([drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag]='O') then 'Y' else 'N', [Expr1138]=If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then 'Y' else 'N', [Expr1139]=If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then 'Y' else 'N', [Expr1144]=If ([c].[drug_label_assoc_detail_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([c].[drug_label_assoc_detail_id]=NULL) then If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='G') then isnull([dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]) else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='B') then isnull([dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]) else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]=NULL) then [dict_formulary_display].[dict_formulary_display_code] else [dict_formulary_display].[dict_formulary_display_code] else NULL, [Expr1148]=If ([c].[drug_label_assoc_detail_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_desc] else If ([c].[drug_label_assoc_detail_id]=NULL) then If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_desc] else If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_desc] else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='G') then isnull([dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_desc]) else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='B') then isnull([dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_desc]) else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_desc] else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]=NULL) then [dict_formulary_display].[dict_formulary_display_desc] else [dict_formulary_display].[dict_formulary_display_desc] else NULL, [Expr1152]=If ([c].[drug_label_assoc_detail_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_rank_nbr] else If ([c].[drug_label_assoc_detail_id]=NULL) then If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_rank_nbr] else If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_rank_nbr] else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='G') then isnull([dict_formu...721Compute ScalarCompute ScalarDEFINE:([Expr1137]=If ([drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag]='O') then 'Y' else 'N', [Expr1138]=If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then 'Y' else 'N', [Expr1139]=If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then 'Y' else 'N', [Expr1144]=If ([c].[drug_label_assoc_detail_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([c].[drug_label_assoc_detail_id]=NULL) then If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='G') then isnull([dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]) else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='B') then isnull([dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]) else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]=NULL) then [dict_formulary_display].[dict_formulary_display_code] else [dict_formulary_display].[dict_formulary_display_code] else NULL, [Expr1148]=If ([c].[drug_label_assoc_detail_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_desc] else If ([c].[drug_label_assoc_detail_id]=NULL) then If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_desc] else If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_desc] else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='G') then isnull([dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_desc]) else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='B') then isnull([dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_desc]) else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_desc] else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]=NULL) then [dict_formulary_display].[dict_formulary_display_desc] else [dict_formulary_display].[dict_formulary_display_desc] else NULL, [Expr1152]=If ([c].[drug_label_assoc_detail_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_rank_nbr] else If ([c].[drug_label_assoc_detail_id]=NULL) then If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_rank_nbr] else If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_rank_nbr] else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='G') then isnull([dict_formulary_display].[dict_...[Expr1137]=If ([drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag]='O') then 'Y' else 'N', [Expr1138]=If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then 'Y' else 'N', [Expr1139]=If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then 'Y' else 'N', [Expr1144]=If ([c].[drug_label_assoc_detail_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([c].[drug_label_assoc_detail_id]=NULL) then If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='G') then isnull([dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]) else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='B') then isnull([dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]) else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]=NULL) then [dict_formulary_display].[dict_formulary_display_code] else [dict_formulary_display].[dict_formulary_display_code] else NULL, [Expr1148]=If ([c].[drug_label_assoc_detail_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_desc] else If ([c].[drug_label_assoc_detail_id]=NULL) then If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_desc] else If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_desc] else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='G') then isnull([dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_desc]) else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='B') then isnull([dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_desc]) else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_desc] else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]=NULL) then [dict_formulary_display].[dict_formulary_display_desc] else [dict_formulary_display].[dict_formulary_display_desc] else NULL, [Expr1152]=If ([c].[drug_label_assoc_detail_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_rank_nbr] else If ([c].[drug_label_assoc_detail_id]=NULL) then If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_rank_nbr] else If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_rank_nbr] else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='G') then isnull([dict_formulary_display].[dict_formular...3.0621272E+70.03.062127457923502.48[h].[health_care_plan_id], [h].[health_care_plan_name], [formulary].[formulary_id], [dict_pharmacy_type].[dict_pharmacy_type_rank_nbr], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [Expr1121], [Expr1122], [Expr1123], [Expr1137], [Expr1138], [Expr1139], [Expr1140], [Expr1144], [Expr1148], [Expr1152], [Expr1153], [Expr1154], [Expr1155], [Expr1156], [Expr1157], [Expr1158], [Expr1159], [Expr1160], [Expr1161], [Expr1162], [Expr1163], [Expr1164], [Expr1165]NULLPLAN_ROW01.0
|--Parallelism(Gather Streams)732ParallelismGather StreamsNULLNULL3.0621272E+70.02833.705890423499.418[h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[formulary_id], [c].[drug_label_assoc_detail_id], [dict_pharmacy_type].[dict_pharmacy_type_rank_nbr], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [Expr1121], [Expr1122], [Expr1123], [Expr1124], [Expr1125], [Expr1126], [Expr1127], [Expr1128], [Expr1129], [Expr1130], [Expr1131], [Expr1132], [Expr1133], [Expr1134], [Expr1135], [Expr1136], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr]NULLPLAN_ROW-11.0
|--Nested Loops(Left Outer Join, WHERE:(IsFalseOrNull([c].[drug_label_assoc_detail_id]<>NULL)))743Nested LoopsLeft Outer JoinWHERE:(IsFalseOrNull([c].[drug_label_assoc_detail_id]<>NULL))NULL3.0621272E+70.063.99845990420665.713[h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[formulary_id], [c].[drug_label_assoc_detail_id], [dict_pharmacy_type].[dict_pharmacy_type_rank_nbr], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [Expr1121], [Expr1122], [Expr1123], [Expr1124], [Expr1125], [Expr1126], [Expr1127], [Expr1128], [Expr1129], [Expr1130], [Expr1131], [Expr1132], [Expr1133], [Expr1134], [Expr1135], [Expr1136], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr]NULLPLAN_ROW-11.0
|--Nested Loops(Left Outer Join, WHERE:(IsFalseOrNull([c].[drug_label_assoc_detail_id]<>NULL)))754Nested LoopsLeft Outer JoinWHERE:(IsFalseOrNull([c].[drug_label_assoc_detail_id]<>NULL))NULL3.0621272E+70.063.99845990220583.934[h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[formulary_id], [c].[drug_label_assoc_detail_id], [dict_pharmacy_type].[dict_pharmacy_type_rank_nbr], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [Expr1121], [Expr1122], [Expr1123], [Expr1124], [Expr1125], [Expr1126], [Expr1127], [Expr1128], [Expr1129], [Expr1130], [Expr1131], [Expr1132], [Expr1133], [Expr1134], [Expr1135], [Expr1136], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc]NULLPLAN_ROW-11.0
| |--Nested Loops(Left Outer Join, WHERE:(IsFalseOrNull([c].[drug_label_assoc_detail_id]<>NULL)))765Nested LoopsLeft Outer JoinWHERE:(IsFalseOrNull([c].[drug_label_assoc_detail_id]<>NULL))NULL3.0621272E+70.063.99845985920502.154[h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[formulary_id], [c].[drug_label_assoc_detail_id], [dict_pharmacy_type].[dict_pharmacy_type_rank_nbr], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [Expr1121], [Expr1122], [Expr1123], [Expr1124], [Expr1125], [Expr1126], [Expr1127], [Expr1128], [Expr1129], [Expr1130], [Expr1131], [Expr1132], [Expr1133], [Expr1134], [Expr1135], [Expr1136], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | |--Hash Match(Right Outer Join, HASH:([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])=([h].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([copay].[copay_id]=[h].[copay_id] AND [drug_label_assoc_detail].[drug_label_assoc_detail_id]=[drug_label_assoc_detail].[drug_label_assoc_detail_id]))776Hash MatchRight Outer JoinHASH:([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])=([h].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([copay].[copay_id]=[h].[copay_id] AND [drug_label_assoc_detail].[drug_label_assoc_detail_id]=[drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL3.0621272E+76081.3511426.6157285420420.377[h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[formulary_id], [c].[drug_label_assoc_detail_id], [dict_pharmacy_type].[dict_pharmacy_type_rank_nbr], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [Expr1121], [Expr1122], [Expr1123], [Expr1124], [Expr1125], [Expr1126], [Expr1127], [Expr1128], [Expr1129], [Expr1130], [Expr1131], [Expr1132], [Expr1133], [Expr1134], [Expr1135], [Expr1136]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]))787ParallelismRepartition StreamsPARTITION COLUMNS:([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL1830125.10.069.157814398143.10631[dict_pharmacy_type].[dict_pharmacy_type_rank_nbr], [copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [Expr1121], [Expr1122], [Expr1123], [Expr1124], [Expr1125], [Expr1126], [Expr1127], [Expr1128], [Expr1129], [Expr1130], [Expr1131], [Expr1132], [Expr1133], [Expr1134], [Expr1135], [Expr1136]NULLPLAN_ROW-11.0
| | | | |--Hash Match(Right Outer Join, HASH:([dict_pharmacy_type].[dict_pharmacy_type_code])=([Expr1124]), RESIDUAL:([Expr1124]=[dict_pharmacy_type].[dict_pharmacy_type_code]))798Hash MatchRight Outer JoinHASH:([dict_pharmacy_type].[dict_pharmacy_type_code])=([Expr1124]), RESIDUAL:([Expr1124]=[dict_pharmacy_type].[dict_pharmacy_type_code])NULL1830125.10.08.001068139873.948494[dict_pharmacy_type].[dict_pharmacy_type_rank_nbr], [copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [Expr1121], [Expr1122], [Expr1123], [Expr1124], [Expr1125], [Expr1126], [Expr1127], [Expr1128], [Expr1129], [Expr1130], [Expr1131], [Expr1132], [Expr1133], [Expr1134], [Expr1135], [Expr1136]NULLPLAN_ROW-11.0
| | | | |--Parallelism(Broadcast)7109ParallelismBroadcastNULLNULL6.00.02.8516209E-2336.6179812E-2[dict_pharmacy_type].[dict_pharmacy_type_code], [dict_pharmacy_type].[dict_pharmacy_type_rank_nbr]NULLPLAN_ROW-11.0
| | | | | |--Clustered Index Scan(OBJECT:([iscribedb1].[dbo].[dict_pharmacy_type].[PK_dict_pharmacy_type]))71110Clustered Index ScanClustered Index ScanOBJECT:([iscribedb1].[dbo].[dict_pharmacy_type].[PK_dict_pharmacy_type])[dict_pharmacy_type].[dict_pharmacy_type_code], [dict_pharmacy_type].[dict_pharmacy_type_rank_nbr]6.03.7578501E-20.0000851333.7663601E-2[dict_pharmacy_type].[dict_pharmacy_type_code], [dict_pharmacy_type].[dict_pharmacy_type_rank_nbr]NULLPLAN_ROW01.0
| | | | |--Compute Scalar(DEFINE:([Expr1121]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1107] else 'N', [Expr1122]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1108] else 'N', [Expr1123]=If (([Expr1112]=NULL AND [Expr1113]=NULL) AND [Expr1114]=NULL) then 'Y' else 'N', [Expr1124]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1110] else [copay_formulary_status].[copay_pharmacy_type], [Expr1125]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1111] else [copay_formulary_status].[copay_first_term], [Expr1126]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1112] else [copay_formulary_status].[copay_flat_dollar_amount], [Expr1127]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1113] else [copay_formulary_status].[copay_percent], [Expr1128]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1114] else [copay_formulary_status].[dict_copay_display_id], [Expr1129]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1115] else [copay_formulary_status].[copay_min_dollar_amount], [Expr1130]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1116] else [copay_formulary_status].[copay_max_dollar_amount], [Expr1131]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1117] else [copay_formulary_status].[copay_days_supply], [Expr1132]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1118] else [copay_formulary_status].[copay_max_tier], [Expr1133]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1119] else [copay_formulary_status].[copay_short], [Expr1134]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1120] else [copay_formulary_status].[copay_long], [Expr1135]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then NULL else [copay_formulary_status].[out_of_pocket_range_start], [Expr1136]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then NULL else [copay_formulary_status].[out_of_pocket_range_end]))7129Compute ScalarCompute ScalarDEFINE:([Expr1121]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1107] else 'N', [Expr1122]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1108] else 'N', [Expr1123]=If (([Expr1112]=NULL AND [Expr1113]=NULL) AND [Expr1114]=NULL) then 'Y' else 'N', [Expr1124]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1110] else [copay_formulary_status].[copay_pharmacy_type], [Expr1125]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1111] else [copay_formulary_status].[copay_first_term], [Expr1126]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1112] else [copay_formulary_status].[copay_flat_dollar_amount], [Expr1127]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1113] else [copay_formulary_status].[copay_percent], [Expr1128]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1114] else [copay_formulary_status].[dict_copay_display_id], [Expr1129]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1115] else [copay_formulary_status].[copay_min_dollar_amount], [Expr1130]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1116] else [copay_formulary_status].[copay_max_dollar_amount], [Expr1131]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1117] else [copay_formulary_status].[copay_days_supply], [Expr1132]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1118] else [copay_formulary_status].[copay_max_tier], [Expr1133]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1119] else [copay_formulary_status].[copay_short], [Expr1134]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1120] else [copay_formulary_status].[copay_long], [Expr1135]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then NULL else [copay_formulary_status].[out_of_pocket_range_start], [Expr1136]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then NULL else [copay_formulary_status].[out_of_pocket_range_end])[Expr1121]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1107] else 'N', [Expr1122]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1108] else 'N', [Expr1123]=If (([Expr1112]=NULL AND [Expr1113]=NULL) AND [Expr1114]=NULL) then 'Y' else 'N', [Expr1124]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1110] else [copay_formulary_status].[copay_pharmacy_type], [Expr1125]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1111] else [copay_formulary_status].[copay_first_term], [Expr1126]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1112] else [copay_formulary_status].[copay_flat_dollar_amount], [Expr1127]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1113] else [copay_formulary_status].[copay_percent], [Expr1128]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1114] else [copay_formulary_status].[dict_copay_display_id], [Expr1129]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1115] else [copay_formulary_status].[copay_min_dollar_amount], [Expr1130]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1116] else [copay_formulary_status].[copay_max_dollar_amount], [Expr1131]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1117] else [copay_formulary_status].[copay_days_supply], [Expr1132]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1118] else [copay_formulary_status].[copay_max_tier], [Expr1133]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1119] else [copay_formulary_status].[copay_short], [Expr1134]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then [Expr1120] else [copay_formulary_status].[copay_long], [Expr1135]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then NULL else [copay_formulary_status].[out_of_pocket_range_start], [Expr1136]=If (([Expr1112]<>NULL OR [Expr1113]<>NULL) OR [Expr1114]<>NULL) then NULL else [copay_formulary_status].[out_of_pocket_range_end]1830125.10.09.1506258E-239165.881241[copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [Expr1121], [Expr1122], [Expr1123], [Expr1124], [Expr1125], [Expr1126], [Expr1127], [Expr1128], [Expr1129], [Expr1130], [Expr1131], [Expr1132], [Expr1133], [Expr1134], [Expr1135], [Expr1136]NULLPLAN_ROW-11.0
| | | | |--Hash Match(Right Outer Join, HASH:([copay_formulary_status].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])=([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([copay_formulary_status].[copay_id]=[copay].[copay_id] AND [drug_label_assoc_detail].[drug_label_assoc_detail_id]=[drug_label_assoc_detail].[drug_label_assoc_detail_id]))71312Hash MatchRight Outer JoinHASH:([copay_formulary_status].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])=([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([copay_formulary_status].[copay_id]=[copay].[copay_id] AND [drug_label_assoc_detail].[drug_label_assoc_detail_id]=[drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL1830125.10.08.086357174665.789734[copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [Expr1107], [Expr1108], [Expr1110], [Expr1111], [Expr1112], [Expr1113], [Expr1114], [Expr1115], [Expr1116], [Expr1117], [Expr1118], [Expr1119], [Expr1120]NULLPLAN_ROW-11.0
| | | | |--Filter(WHERE:(If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='G') then isnull([dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]) else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='B') then isnull([dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]) else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]=NULL) then [dict_formulary_display].[dict_formulary_display_code] else [dict_formulary_display].[dict_formulary_display_code]=[dict_formulary_display].[dict_formulary_display_code]))71413FilterFilterWHERE:(If ([formulary_drug_label_assoc_detail].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='G') then isnull([dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]) else If ([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='B') then isnull([dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]) else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]<>NULL) then [dict_formulary_display].[dict_formulary_display_code] else If ((([formulary_drug_label].[dict_formulary_display_id]=NULL AND [drug_label].[drug_label_type_code]='N') AND [drug_label].[drug_label_on_patent_brand_id]<>NULL) AND [formulary_drug_label].[dict_formulary_display_id]=NULL) then [dict_formulary_display].[dict_formulary_display_code] else [dict_formulary_display].[dict_formulary_display_code]=[dict_formulary_display].[dict_formulary_display_code])NULL648.200010.00.0216498843624.236858[copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [drug_label_assoc_detail].[drug_label_assoc_detail_id]NULLPLAN_ROW-11.0
| | | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([copay_formulary_status].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]))71514ParallelismRepartition StreamsPARTITION COLUMNS:([copay_formulary_status].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL6482.00.00.3158341143624.215208[copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | |--Hash Match(Right Outer Join, HASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary].[default_brand_dict_formulary_display_id]))71615Hash MatchRight Outer JoinHASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary].[default_brand_dict_formulary_display_id])NULL6482.00.04.0862802E-243623.899374[copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | |--Parallelism(Distribute Streams, PARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id]))71716ParallelismDistribute StreamsPARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id])NULL225.00.02.9219888E-2710.06860587[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))71817Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]225.03.9059982E-23.2600001E-4713.9385982E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW01.0
| | | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary].[default_brand_dict_formulary_display_id]))71916ParallelismRepartition StreamsPARTITION COLUMNS:([formulary].[default_brand_dict_formulary_display_id])NULL6482.00.00.3122268643323.789902[formulary].[default_brand_dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | |--Hash Match(Right Outer Join, HASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary].[default_generic_dict_formulary_display_id]))72019Hash MatchRight Outer JoinHASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary].[default_generic_dict_formulary_display_id])NULL6482.00.04.7171138E-243323.477674[formulary].[default_brand_dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | |--Parallelism(Distribute Streams, PARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id]))72120ParallelismDistribute StreamsPARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id])NULL225.00.02.9219888E-2710.06860587[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))72221Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]225.03.9059982E-23.2600001E-4713.9385982E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW01.0
| | | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary].[default_generic_dict_formulary_display_id]))72320ParallelismRepartition StreamsPARTITION COLUMNS:([formulary].[default_generic_dict_formulary_display_id])NULL6482.00.00.310885142823.361895[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | |--Hash Match(Right Outer Join, HASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary_drug_label].[dict_formulary_display_id]))72423Hash MatchRight Outer JoinHASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary_drug_label].[dict_formulary_display_id])NULL6482.00.04.1290946E-242823.05101[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | |--Parallelism(Distribute Streams, PARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id]))72524ParallelismDistribute StreamsPARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id])NULL225.00.02.9219888E-2710.06860587[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))72625Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]225.03.9059982E-23.2600001E-4713.9385982E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW01.0
| | | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary_drug_label].[dict_formulary_display_id]))72724ParallelismRepartition StreamsPARTITION COLUMNS:([formulary_drug_label].[dict_formulary_display_id])NULL6482.00.00.30551842322.941111[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | |--Hash Match(Right Outer Join, HASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary_drug_label_assoc_detail].[dict_formulary_display_id]))72827Hash MatchRight Outer JoinHASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary_drug_label_assoc_detail].[dict_formulary_display_id])NULL6482.00.03.9563645E-242322.635592[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | |--Parallelism(Distribute Streams, PARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id]))72928ParallelismDistribute StreamsPARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id])NULL225.00.02.9219888E-2710.06860587[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))73029Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]225.03.9059982E-23.2600001E-4713.9385982E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW01.0
| | | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary_drug_label_assoc_detail].[dict_formulary_display_id]))73128ParallelismRepartition StreamsPARTITION COLUMNS:([formulary_drug_label_assoc_detail].[dict_formulary_display_id])NULL6482.00.00.300150954322.52742[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | |--Nested Loops(Left Outer Join, OUTER REFERENCES:([formulary].[formulary_id], [drug_label].[drug_label_on_patent_brand_id]) WITH PREFETCH)73231Nested LoopsLeft Outer JoinOUTER REFERENCES:([formulary].[formulary_id], [drug_label].[drug_label_on_patent_brand_id]) WITH PREFETCHNULL6482.00.00.0135473854322.227268[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | |--Nested Loops(Left Outer Join, OUTER REFERENCES:([formulary].[formulary_id], [drug_label].[drug_label_id]))73432Nested LoopsLeft Outer JoinOUTER REFERENCES:([formulary].[formulary_id], [drug_label].[drug_label_id])NULL6482.00.00.0135473851015.262808[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | | |--Sort(ORDER BY:([formulary].[formulary_id] ASC, [drug_label].[drug_label_on_patent_brand_id] ASC))73534SortSortORDER BY:([formulary].[formulary_id] ASC, [drug_label].[drug_label_on_patent_brand_id] ASC)NULL6482.05.6306305E-39.9607617E-24145.5320344[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | | | |--Merge Join(Right Outer Join, MERGE:([formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id])=([formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([formulary_drug_label_assoc_detail].[formulary_id]=[formulary].[formulary_id] AND [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id]=[drug_label_assoc_detail].[drug_label_assoc_detail_id]))73635Merge JoinRight Outer JoinMERGE:([formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id])=([formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([formulary_drug_label_assoc_detail].[formulary_id]=[formulary].[formulary_id] AND [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id]=[drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL6482.00.00.811727174455.4267964[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id]), ORDER BY:([formulary_drug_label_assoc_detail].[formulary_id] ASC, [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id] ASC), WHERE:(PROBE([Bitmap1483])=TRUE))73736ParallelismRepartition StreamsPARTITION COLUMNS:([formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id]), ORDER BY:([formulary_drug_label_assoc_detail].[formulary_id] ASC, [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id] ASC), WHERE:(PROBE([Bitmap1483])=TRUE)NULL361583.00.01.5113518413.0419145[formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id], [formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[dict_formulary_display_id]NULLPLAN_ROW-11.0
| | | | | | | | |--Clustered Index Scan(OBJECT:([iscribedb1].[dbo].[formulary_drug_label_assoc_detail].[uk_formulary_drug_label_assoc_detail]), ORDERED FORWARD)73837Clustered Index ScanClustered Index ScanOBJECT:([iscribedb1].[dbo].[formulary_drug_label_assoc_detail].[uk_formulary_drug_label_assoc_detail]), ORDERED FORWARD[formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id], [formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[dict_formulary_display_id]361583.01.33165250.19890989411.5305625[formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id], [formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[dict_formulary_display_id]NULLPLAN_ROW-11.0
| | | | | | | |--Sort(ORDER BY:([formulary].[formulary_id] ASC, [drug_label_assoc_detail].[drug_label_assoc_detail_id] ASC))73936SortSortORDER BY:([formulary].[formulary_id] ASC, [drug_label_assoc_detail].[drug_label_assoc_detail_id] ASC)NULL6482.05.6306305E-39.9607617E-24121.5731479[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | | | |--Bitmap(HASH:([formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), DEFINE:([Bitmap1483]))74039BitmapBitmap CreateHASH:([formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])[Bitmap1483]6482.00.00.29436574651.4679096[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]))74140ParallelismRepartition StreamsPARTITION COLUMNS:([formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL6482.00.00.29436574651.4679096[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | | | |--Merge Join(Inner Join, MERGE:([drug_label].[drug_label_id])=([drug_label_assoc_detail].[drug_label_id]), RESIDUAL:([drug_label].[drug_label_id]=[drug_label_assoc_detail].[drug_label_id]))74241Merge JoinInner JoinMERGE:([drug_label].[drug_label_id])=([drug_label_assoc_detail].[drug_label_id]), RESIDUAL:([drug_label].[drug_label_id]=[drug_label_assoc_detail].[drug_label_id])NULL6482.00.09.1056973E-24651.1735439[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([drug_label].[drug_label_id]), ORDER BY:([drug_label].[drug_label_id] ASC), WHERE:(PROBE([Bitmap1482])=TRUE))74342ParallelismRepartition StreamsPARTITION COLUMNS:([drug_label].[drug_label_id]), ORDER BY:([drug_label].[drug_label_id] ASC), WHERE:(PROBE([Bitmap1482])=TRUE)NULL31336.00.00.14699708660.30703482[drug_label].[drug_label_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code]NULLPLAN_ROW-11.0
| | | | | | | | |--Index Scan(OBJECT:([iscribedb1].[dbo].[drug_label].[ix_drug_label_1]), ORDERED FORWARD)74443Index ScanIndex ScanOBJECT:([iscribedb1].[dbo].[drug_label].[ix_drug_label_1]), ORDERED FORWARD[drug_label].[drug_label_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code]31336.07.1381845E-28.637025E-3660.16003774[drug_label].[drug_label_id], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code]NULLPLAN_ROW-11.0
| | | | | | | |--Sort(ORDER BY:([drug_label_assoc_detail].[drug_label_id] ASC))74542SortSortORDER BY:([drug_label_assoc_detail].[drug_label_id] ASC)NULL6482.05.6306305E-39.9607609E-24070.7754491[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | | | |--Bitmap(HASH:([drug_label_assoc_detail].[drug_label_id]), DEFINE:([Bitmap1482]))74645BitmapBitmap CreateHASH:([drug_label_assoc_detail].[drug_label_id])[Bitmap1482]6482.00.00.284244065650.67021084[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
Parallelism(Repartition Streams, PARTITION COLUMNS:([drug_label_assoc_detail].[drug_label_id]))74746ParallelismRepartition StreamsPARTITION COLUMNS:([drug_label_assoc_detail].[drug_label_id])NULL6482.00.00.284244065650.67021084[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
Nested Loops(Inner Join)74847Nested LoopsInner JoinNULLNULL6482.00.04.0642139E-25650.38596678[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
|--Nested Loops(Inner Join)74948Nested LoopsInner JoinNULLNULL1.00.00.000002095350.27723116[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| |--Parallelism(Broadcast)75049ParallelismBroadcastNULLNULL1.00.02.8502081E-2713.1835034E-2[dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | |--Bookmark Lookup(BOOKMARK:([Bmk1084]), OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))75150Bookmark LookupBookmark LookupBOOKMARK:([Bmk1084]), OBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_code]1.04.8826954E-50.0000011713.3329551E-3[dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW01.0
| | |--Index Seek(OBJECT:([iscribedb1].[dbo].[dict_formulary_display].[uk_dict_formulary_display_old_code]), SEEK:([dict_formulary_display].[dict_formulary_display_old_code]='U') ORDERED FORWARD)75251Index SeekIndex SeekOBJECT:([iscribedb1].[dbo].[dict_formulary_display].[uk_dict_formulary_display_old_code]), SEEK:([dict_formulary_display].[dict_formulary_display_old_code]='U') ORDERED FORWARD[Bmk1084]1.03.2034251E-37.9603E-5183.283028E-3[Bmk1084]NULLPLAN_ROW01.0
| |--Bookmark Lookup(BOOKMARK:([Bmk1050]), OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))75349Bookmark LookupBookmark LookupBOOKMARK:([Bmk1050]), OBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_code]1.04.8826954E-55.4999998E-74720.24539402[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| |--Nested Loops(Inner Join, OUTER REFERENCES:([copay_formulary_status].[dict_formulary_display_id]))75453Nested LoopsInner JoinOUTER REFERENCES:([copay_formulary_status].[dict_formulary_display_id])NULL1.00.06.2700001E-64170.24534465[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [Bmk1050]NULLPLAN_ROW-11.0
| |--Bookmark Lookup(BOOKMARK:([Bmk1044]), OBJECT:([iscribedb1].[dbo].[formulary]))75554Bookmark LookupBookmark LookupBOOKMARK:([Bmk1044]), OBJECT:([iscribedb1].[dbo].[formulary])[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id]1.04.8826954E-55.4999998E-74090.24181765[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [copay_formulary_status].[dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end]NULLPLAN_ROW-11.0
| | |--Nested Loops(Inner Join, OUTER REFERENCES:([health_care_plan].[formulary_id]))75655Nested LoopsInner JoinOUTER REFERENCES:([health_care_plan].[formulary_id])NULL1.00.06.2700001E-64050.24176827[Bmk1044], [copay_formulary_status].[dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end]NULLPLAN_ROW-11.0
| | | |--Hash Match(Inner Join, HASH:([copay_list].[copay_id])=([health_care_plan].[copay_id]), RESIDUAL:([health_care_plan].[copay_id]=[copay_list].[copay_id]))75756Hash MatchInner JoinHASH:([copay_list].[copay_id])=([health_care_plan].[copay_id]), RESIDUAL:([health_care_plan].[copay_id]=[copay_list].[copay_id])NULL1.00.05.6528036E-23950.23824127[health_care_plan].[formulary_id], [copay_formulary_status].[dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end]NULLPLAN_ROW-11.0
| | | | |--Parallelism(Broadcast)75857ParallelismBroadcastNULLNULL1.00.02.8534994E-24876.9772668E-2[copay_formulary_status].[dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [copay_list].[copay_id]NULLPLAN_ROW-11.0
| | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([copay_list].[copay_id]))75958Nested LoopsInner JoinOUTER REFERENCES:([copay_list].[copay_id])NULL1.00.00.000012544874.1237675E-2[copay_formulary_status].[dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end], [copay_list].[copay_id]NULLPLAN_ROW01.0
| | | | | |--Clustered Index Scan(OBJECT:([iscribedb1].[dbo].[copay_list].[uk_copay_list]), WHERE:([copay_list].[copay_list_type]='SL'))76059Clustered Index ScanClustered Index ScanOBJECT:([iscribedb1].[dbo].[copay_list].[uk_copay_list]), WHERE:([copay_list].[copay_list_type]='SL')[copay_list].[copay_id], [copay_list].[copay_list_type]1.03.7578501E-20.0001115913.7689999E-2[copay_list].[copay_id], [copay_list].[copay_list_type]NULLPLAN_ROW01.0
| | | | | |--Clustered Index Seek(OBJECT:([iscribedb1].[dbo].[copay_formulary_status].[uk_copay_formulary_status_1]), SEEK:([copay_formulary_status].[copay_id]=[copay_list].[copay_id]) ORDERED FORWARD)76159Clustered Index SeekClustered Index SeekOBJECT:([iscribedb1].[dbo].[copay_formulary_status].[uk_copay_formulary_status_1]), SEEK:([copay_formulary_status].[copay_id]=[copay_list].[copay_id]) ORDERED FORWARD[copay_formulary_status].[dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end]1.03.2034251E-37.9603E-54043.5207339E-3[copay_formulary_status].[dict_formulary_display_id], [copay_formulary_status].[copay_id], [copay_formulary_status].[copay_pharmacy_type], [copay_formulary_status].[copay_first_term], [copay_formulary_status].[copay_flat_dollar_amount], [copay_formulary_status].[copay_percent], [copay_formulary_status].[dict_copay_display_id], [copay_formulary_status].[copay_min_dollar_amount], [copay_formulary_status].[copay_max_dollar_amount], [copay_formulary_status].[copay_days_supply], [copay_formulary_status].[copay_max_tier], [copay_formulary_status].[copay_short], [copay_formulary_status].[copay_long], [copay_formulary_status].[out_of_pocket_range_start], [copay_formulary_status].[out_of_pocket_range_end]NULLPLAN_ROW03.0
| | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[health_care_plan]))76257Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[health_care_plan])[health_care_plan].[formulary_id], [health_care_plan].[copay_id]5834.00.108689610.00324795840.11193756[health_care_plan].[formulary_id], [health_care_plan].[copay_id]NULLPLAN_ROW-11.0
| | | |--Index Seek(OBJECT:([iscribedb1].[dbo].[formulary].[pk_formulary]), SEEK:([formulary].[formulary_id]=[health_care_plan].[formulary_id]) ORDERED FORWARD)76456Index SeekIndex SeekOBJECT:([iscribedb1].[dbo].[formulary].[pk_formulary]), SEEK:([formulary].[formulary_id]=[health_care_plan].[formulary_id]) ORDERED FORWARD[Bmk1044]1.03.2034251E-37.9603E-5193.5207339E-3[Bmk1044]NULLPLAN_ROW-13.0
| |--Index Seek(OBJECT:([iscribedb1].[dbo].[dict_formulary_display].[pk_dict_formulary_display]), SEEK:([dict_formulary_display].[dict_formulary_display_id]=[copay_formulary_status].[dict_formulary_display_id]) ORDERED FORWARD)76554Index SeekIndex SeekOBJECT:([iscribedb1].[dbo].[dict_formulary_display].[pk_dict_formulary_display]), SEEK:([dict_formulary_display].[dict_formulary_display_id]=[copay_formulary_status].[dict_formulary_display_id]) ORDERED FORWARD[Bmk1050]1.03.2034251E-37.9603E-5173.5207339E-3[Bmk1050]NULLPLAN_ROW-13.0
|--Index Scan(OBJECT:([iscribedb1].[dbo].[drug_label_assoc_detail].[pk_drug_label_assoc_detail]))76648Index ScanIndex ScanOBJECT:([iscribedb1].[dbo].[drug_label_assoc_detail].[pk_drug_label_assoc_detail])[drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]6482.00.046467397.2086998E-3396.8093486E-2[drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]NULLPLAN_ROW-13.0
| | | | | | |--Nested Loops(Left Outer Join, WHERE:([formulary_drug_label].[dict_formulary_display_id]=[dict_formulary_display].[dict_formulary_display_id]))77734Nested LoopsLeft Outer JoinWHERE:([formulary_drug_label].[dict_formulary_display_id]=[dict_formulary_display].[dict_formulary_display_id])NULL1.00.00.00094051049.717226[formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-16482.0
| | | | | | |--Clustered Index Seek(OBJECT:([iscribedb1].[dbo].[formulary_drug_label].[uk_formulary_drug_label_1]), SEEK:([formulary_drug_label].[formulary_id]=[formulary].[formulary_id] AND [formulary_drug_label].[drug_label_id]=[drug_label].[drug_label_id]) ORDERED FORWARD)77877Clustered Index SeekClustered Index SeekOBJECT:([iscribedb1].[dbo].[formulary_drug_label].[uk_formulary_drug_label_1]), SEEK:([formulary_drug_label].[formulary_id]=[formulary].[formulary_id] AND [formulary_drug_label].[drug_label_id]=[drug_label].[drug_label_id]) ORDERED FORWARD[formulary_drug_label].[dict_formulary_display_id]1.03.2034251E-37.9607002E-5410.52241945[formulary_drug_label].[dict_formulary_display_id]NULLPLAN_ROW-16482.0
| | | | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))77977Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]225.03.9059982E-23.2600001E-4712.6609504[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-16482.0
| | | | | |--Clustered Index Seek(OBJECT:([iscribedb1].[dbo].[formulary_drug_label].[uk_formulary_drug_label_1]), SEEK:([formulary_drug_label].[formulary_id]=[formulary].[formulary_id] AND [formulary_drug_label].[drug_label_id]=[drug_label].[drug_label_on_patent_brand_id]) ORDERED FORWARD)78332Clustered Index SeekClustered Index SeekOBJECT:([iscribedb1].[dbo].[formulary_drug_label].[uk_formulary_drug_label_1]), SEEK:([formulary_drug_label].[formulary_id]=[formulary].[formulary_id] AND [formulary_drug_label].[drug_label_id]=[drug_label].[drug_label_on_patent_brand_id]) ORDERED FORWARD[formulary_drug_label].[dict_formulary_display_id]1.03.2034251E-37.9607002E-5416.9509139[formulary_drug_label].[dict_formulary_display_id]NULLPLAN_ROW-16482.0
| | | | |--Hash Match(Left Outer Join, HASH:([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])=([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([copay].[copay_id]=[copay].[copay_id] AND [drug_label_assoc_detail].[drug_label_assoc_detail_id]=[drug_label_assoc_detail].[drug_label_assoc_detail_id]))715713Hash MatchLeft Outer JoinHASH:([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])=([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([copay].[copay_id]=[copay].[copay_id] AND [drug_label_assoc_detail].[drug_label_assoc_detail_id]=[drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL1830125.10.08.956271237933.466515[copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [Expr1107], [Expr1108], [Expr1110], [Expr1111], [Expr1112], [Expr1113], [Expr1114], [Expr1115], [Expr1116], [Expr1117], [Expr1118], [Expr1119], [Expr1120]NULLPLAN_ROW-11.0
| | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]))7158157ParallelismRepartition StreamsPARTITION COLUMNS:([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL627712.250.02.2129385193.9903407[copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]NULLPLAN_ROW-11.0
| | | | | |--Nested Loops(Inner Join)7159158Nested LoopsInner JoinNULLNULL627712.250.01.3119186191.777402[copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]NO JOIN PREDICATEPLAN_ROW-11.0
| | | | | |--Hash Match(Inner Join, HASH:([copay].[copay_id])=([health_care_plan].[copay_id]), RESIDUAL:([health_care_plan].[copay_id]=[copay].[copay_id]))7160159Hash MatchInner JoinHASH:([copay].[copay_id])=([health_care_plan].[copay_id]), RESIDUAL:([health_care_plan].[copay_id]=[copay].[copay_id])NULL96.8392870.05.6578185E-2150.23476495[copay].[copay_id]NULLPLAN_ROW-11.0
| | | | | | |--Parallelism(Broadcast)7161160ParallelismBroadcastNULLNULL30.00.02.8556205E-2566.6246204E-2[copay].[copay_id]NULLPLAN_ROW-11.0
| | | | | | | |--Index Scan(OBJECT:([iscribedb1].[dbo].[copay].[uk_copay]))7162161Index ScanIndex ScanOBJECT:([iscribedb1].[dbo].[copay].[uk_copay])[copay].[copay_id]30.03.7578501E-20.0001115563.7689999E-2[copay].[copay_id]NULLPLAN_ROW01.0
| | | | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[health_care_plan]))7163160Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[health_care_plan])[health_care_plan].[copay_id]5834.00.108689610.00324795840.11193756[health_care_plan].[copay_id]NULLPLAN_ROW-11.0
| | | | | |--Table Spool7165159Table SpoolLazy SpoolNULLNULL6482.06.4054057E-20.00116686110.23071845[drug_label_assoc_detail].[drug_label_assoc_detail_id]NULLPLAN_ROW-196.839287
| | | | | |--Index Scan(OBJECT:([iscribedb1].[dbo].[drug_label_assoc_detail].[pk_drug_label_assoc_detail]))7166165Index ScanIndex ScanOBJECT:([iscribedb1].[dbo].[drug_label_assoc_detail].[pk_drug_label_assoc_detail])[drug_label_assoc_detail].[drug_label_assoc_detail_id]6482.00.046467397.2086998E-3395.3676087E-2[drug_label_assoc_detail].[drug_label_assoc_detail_id]NULLPLAN_ROW-11.0
| | | | |--Compute Scalar(DEFINE:([Expr1107]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then 'Y' else 'N', [Expr1108]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then 'N' else 'Y', [Expr1110]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_pharmacy_type] else [copay_drug_label].[copay_pharmacy_type], [Expr1111]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_first_term] else [copay_drug_label].[copay_first_term], [Expr1112]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_flat_dollar_amount] else [copay_drug_label].[copay_flat_dollar_amount], [Expr1113]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_percent] else [copay_drug_label].[copay_percent], [Expr1114]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[dict_copay_display_id] else [copay_drug_label].[dict_copay_display_id], [Expr1115]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_min_dollar_amount] else [copay_drug_label].[copay_min_dollar_amount], [Expr1116]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_max_dollar_amount] else [copay_drug_label].[copay_max_dollar_amount], [Expr1117]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_days_supply] else [copay_drug_label].[copay_days_supply], [Expr1118]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_max_tier] else [copay_drug_label].[copay_max_tier], [Expr1119]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_short] else [copay_drug_label].[copay_short], [Expr1120]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_long] else [copay_drug_label].[copay_long]))7167157Compute ScalarCompute ScalarDEFINE:([Expr1107]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then 'Y' else 'N', [Expr1108]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then 'N' else 'Y', [Expr1110]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_pharmacy_type] else [copay_drug_label].[copay_pharmacy_type], [Expr1111]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_first_term] else [copay_drug_label].[copay_first_term], [Expr1112]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_flat_dollar_amount] else [copay_drug_label].[copay_flat_dollar_amount], [Expr1113]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_percent] else [copay_drug_label].[copay_percent], [Expr1114]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[dict_copay_display_id] else [copay_drug_label].[dict_copay_display_id], [Expr1115]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_min_dollar_amount] else [copay_drug_label].[copay_min_dollar_amount], [Expr1116]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_max_dollar_amount] else [copay_drug_label].[copay_max_dollar_amount], [Expr1117]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_days_supply] else [copay_drug_label].[copay_days_supply], [Expr1118]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_max_tier] else [copay_drug_label].[copay_max_tier], [Expr1119]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_short] else [copay_drug_label].[copay_short], [Expr1120]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_long] else [copay_drug_label].[copay_long])[Expr1107]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then 'Y' else 'N', [Expr1108]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then 'N' else 'Y', [Expr1110]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_pharmacy_type] else [copay_drug_label].[copay_pharmacy_type], [Expr1111]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_first_term] else [copay_drug_label].[copay_first_term], [Expr1112]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_flat_dollar_amount] else [copay_drug_label].[copay_flat_dollar_amount], [Expr1113]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_percent] else [copay_drug_label].[copay_percent], [Expr1114]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[dict_copay_display_id] else [copay_drug_label].[dict_copay_display_id], [Expr1115]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_min_dollar_amount] else [copay_drug_label].[copay_min_dollar_amount], [Expr1116]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_max_dollar_amount] else [copay_drug_label].[copay_max_dollar_amount], [Expr1117]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_days_supply] else [copay_drug_label].[copay_days_supply], [Expr1118]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_max_tier] else [copay_drug_label].[copay_max_tier], [Expr1119]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_short] else [copay_drug_label].[copay_short], [Expr1120]=If (([copay_drug_label_assoc_detail].[copay_flat_dollar_amount]<>NULL OR [copay_drug_label_assoc_detail].[copay_percent]<>NULL) OR [copay_drug_label_assoc_detail].[dict_copay_display_id]<>NULL) then [copay_drug_label_assoc_detail].[copay_long] else [copay_drug_label].[copay_long]243337.450.01.2166873E-237020.519896[copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [Expr1107], [Expr1108], [Expr1110], [Expr1111], [Expr1112], [Expr1113], [Expr1114], [Expr1115], [Expr1116], [Expr1117], [Expr1118], [Expr1119], [Expr1120]NULLPLAN_ROW-11.0
| | | | |--Hash Match(Right Outer Join, HASH:([copay_drug_label_assoc_detail].[copay_id], [copay_drug_label_assoc_detail].[drug_label_assoc_detail_id])=([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([copay_drug_label_assoc_detail].[copay_id]=[copay].[copay_id] AND [copay_drug_label_assoc_detail].[drug_label_assoc_detail_id]=[drug_label_assoc_detail].[drug_label_assoc_detail_id]))7168167Hash MatchRight Outer JoinHASH:([copay_drug_label_assoc_detail].[copay_id], [copay_drug_label_assoc_detail].[drug_label_assoc_detail_id])=([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([copay_drug_label_assoc_detail].[copay_id]=[copay].[copay_id] AND [copay_drug_label_assoc_detail].[drug_label_assoc_detail_id]=[drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL243337.450.02.794732872420.507729[copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [copay_drug_label_assoc_detail].[copay_pharmacy_type], [copay_drug_label_assoc_detail].[copay_first_term], [copay_drug_label_assoc_detail].[copay_min_dollar_amount], [copay_drug_label_assoc_detail].[copay_max_dollar_amount], [copay_drug_label_assoc_detail].[copay_days_supply], [copay_drug_label_assoc_detail].[copay_max_tier], [copay_drug_label_assoc_detail].[copay_short], [copay_drug_label_assoc_detail].[dict_copay_display_id], [copay_drug_label_assoc_detail].[copay_percent], [copay_drug_label_assoc_detail].[copay_flat_dollar_amount], [copay_drug_label_assoc_detail].[copay_long], [copay_drug_label].[copay_pharmacy_type], [copay_drug_label].[copay_first_term], [copay_drug_label].[copay_flat_dollar_amount], [copay_drug_label].[copay_percent], [copay_drug_label].[dict_copay_display_id], [copay_drug_label].[copay_min_dollar_amount], [copay_drug_label].[copay_max_dollar_amount], [copay_drug_label].[copay_days_supply], [copay_drug_label].[copay_max_tier], [copay_drug_label].[copay_short], [copay_drug_label].[copay_long]NULLPLAN_ROW-11.0
| | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([copay_drug_label_assoc_detail].[copay_id], [copay_drug_label_assoc_detail].[drug_label_assoc_detail_id]))7169168ParallelismRepartition StreamsPARTITION COLUMNS:([copay_drug_label_assoc_detail].[copay_id], [copay_drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL14014.00.00.491130173910.68312228[copay_drug_label_assoc_detail].[drug_label_assoc_detail_id], [copay_drug_label_assoc_detail].[copay_id], [copay_drug_label_assoc_detail].[copay_pharmacy_type], [copay_drug_label_assoc_detail].[copay_first_term], [copay_drug_label_assoc_detail].[copay_min_dollar_amount], [copay_drug_label_assoc_detail].[copay_max_dollar_amount], [copay_drug_label_assoc_detail].[copay_days_supply], [copay_drug_label_assoc_detail].[copay_max_tier], [copay_drug_label_assoc_detail].[copay_short], [copay_drug_label_assoc_detail].[dict_copay_display_id], [copay_drug_label_assoc_detail].[copay_percent], [copay_drug_label_assoc_detail].[copay_flat_dollar_amount], [copay_drug_label_assoc_detail].[copay_long]NULLPLAN_ROW-11.0
| | | | | |--Clustered Index Scan(OBJECT:([iscribedb1].[dbo].[copay_drug_label_assoc_detail].[uk_copay_drug_label_assoc_detail]))7170169Clustered Index ScanClustered Index ScanOBJECT:([iscribedb1].[dbo].[copay_drug_label_assoc_detail].[uk_copay_drug_label_assoc_detail])[copay_drug_label_assoc_detail].[drug_label_assoc_detail_id], [copay_drug_label_assoc_detail].[copay_id], [copay_drug_label_assoc_detail].[copay_pharmacy_type], [copay_drug_label_assoc_detail].[copay_first_term], [copay_drug_label_assoc_detail].[copay_min_dollar_amount], [copay_drug_label_assoc_detail].[copay_max_dollar_amount], [copay_drug_label_assoc_detail].[copay_days_supply], [copay_drug_label_assoc_detail].[copay_max_tier], [copay_drug_label_assoc_detail].[copay_short], [copay_drug_label_assoc_detail].[dict_copay_display_id], [copay_drug_label_assoc_detail].[copay_percent], [copay_drug_label_assoc_detail].[copay_flat_dollar_amount], [copay_drug_label_assoc_detail].[copay_long]14014.09.2122585E-23.8734749E-33910.19199212[copay_drug_label_assoc_detail].[drug_label_assoc_detail_id], [copay_drug_label_assoc_detail].[copay_id], [copay_drug_label_assoc_detail].[copay_pharmacy_type], [copay_drug_label_assoc_detail].[copay_first_term], [copay_drug_label_assoc_detail].[copay_min_dollar_amount], [copay_drug_label_assoc_detail].[copay_max_dollar_amount], [copay_drug_label_assoc_detail].[copay_days_supply], [copay_drug_label_assoc_detail].[copay_max_tier], [copay_drug_label_assoc_detail].[copay_short], [copay_drug_label_assoc_detail].[dict_copay_display_id], [copay_drug_label_assoc_detail].[copay_percent], [copay_drug_label_assoc_detail].[copay_flat_dollar_amount], [copay_drug_label_assoc_detail].[copay_long]NO STATS:([copay_drug_label_assoc_detail].[drug_label_assoc_detail_id])PLAN_ROW-11.0
| | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]))7171168ParallelismRepartition StreamsPARTITION COLUMNS:([copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL232061.380.07.689310137817.029867[copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [copay_drug_label].[copay_pharmacy_type], [copay_drug_label].[copay_first_term], [copay_drug_label].[copay_flat_dollar_amount], [copay_drug_label].[copay_percent], [copay_drug_label].[dict_copay_display_id], [copay_drug_label].[copay_min_dollar_amount], [copay_drug_label].[copay_max_dollar_amount], [copay_drug_label].[copay_days_supply], [copay_drug_label].[copay_max_tier], [copay_drug_label].[copay_short], [copay_drug_label].[copay_long]NULLPLAN_ROW-11.0
| | | | |--Hash Match(Left Outer Join, HASH:([copay].[copay_id], [drug_label].[drug_label_id])=([copay_drug_label].[copay_id], [copay_drug_label].[drug_label_id]), RESIDUAL:([copay_drug_label].[copay_id]=[copay].[copay_id] AND [copay_drug_label].[drug_label_id]=[drug_label].[drug_label_id]))7172171Hash MatchLeft Outer JoinHASH:([copay].[copay_id], [drug_label].[drug_label_id])=([copay_drug_label].[copay_id], [copay_drug_label].[drug_label_id]), RESIDUAL:([copay_drug_label].[copay_id]=[copay].[copay_id] AND [copay_drug_label].[drug_label_id]=[drug_label].[drug_label_id])NULL232061.380.02.73253353789.3405571[copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [copay_drug_label].[copay_pharmacy_type], [copay_drug_label].[copay_first_term], [copay_drug_label].[copay_flat_dollar_amount], [copay_drug_label].[copay_percent], [copay_drug_label].[dict_copay_display_id], [copay_drug_label].[copay_min_dollar_amount], [copay_drug_label].[copay_max_dollar_amount], [copay_drug_label].[copay_days_supply], [copay_drug_label].[copay_max_tier], [copay_drug_label].[copay_short], [copay_drug_label].[copay_long]NULLPLAN_ROW-11.0
| | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([copay].[copay_id], [drug_label].[drug_label_id]))7173172ParallelismRepartition StreamsPARTITION COLUMNS:([copay].[copay_id], [drug_label].[drug_label_id])NULL194460.00.00.85281593721.8114089[copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_id]NULLPLAN_ROW-11.0
| | | | | |--Nested Loops(Inner Join)7174173Nested LoopsInner JoinNULLNULL194460.00.00.40642139720.95859301[copay].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_id]NO JOIN PREDICATEPLAN_ROW-11.0
| | | | | |--Merge Join(Inner Join, MERGE:([drug_label].[drug_label_id])=([drug_label_assoc_detail].[drug_label_id]), RESIDUAL:([drug_label].[drug_label_id]=[drug_label_assoc_detail].[drug_label_id]))7175174Merge JoinInner JoinMERGE:([drug_label].[drug_label_id])=([drug_label_assoc_detail].[drug_label_id]), RESIDUAL:([drug_label].[drug_label_id]=[drug_label_assoc_detail].[drug_label_id])NULL6482.00.09.1056973E-2680.46272194[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label].[drug_label_id]NULLPLAN_ROW-11.0
| | | | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([drug_label].[drug_label_id]), ORDER BY:([drug_label].[drug_label_id] ASC))7176175ParallelismRepartition StreamsPARTITION COLUMNS:([drug_label].[drug_label_id]), ORDER BY:([drug_label].[drug_label_id] ASC)NULL31336.00.00.10591559600.2400274[drug_label].[drug_label_id]NULLPLAN_ROW-11.0
| | | | | | | |--Index Scan(OBJECT:([iscribedb1].[dbo].[drug_label].[pk_drug_label]), ORDERED FORWARD)7177176Index ScanIndex ScanOBJECT:([iscribedb1].[dbo].[drug_label].[pk_drug_label]), ORDERED FORWARD[drug_label].[drug_label_id]31336.00.116837760.01727405600.13411181[drug_label].[drug_label_id]NULLPLAN_ROW-11.0
| | | | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([drug_label_assoc_detail].[drug_label_id]), ORDER BY:([drug_label_assoc_detail].[drug_label_id] ASC))7178175ParallelismRepartition StreamsPARTITION COLUMNS:([drug_label_assoc_detail].[drug_label_id]), ORDER BY:([drug_label_assoc_detail].[drug_label_id] ASC)NULL6482.00.05.5636894E-2400.13163456[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id]NULLPLAN_ROW-11.0
| | | | | | |--Clustered Index Scan(OBJECT:([iscribedb1].[dbo].[drug_label_assoc_detail].[uk_drug_label_assoc_detail_1]), ORDERED FORWARD)7179178Clustered Index ScanClustered Index ScanOBJECT:([iscribedb1].[dbo].[drug_label_assoc_detail].[uk_drug_label_assoc_detail_1]), ORDERED FORWARD[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id]6482.07.2393313E-23.6043499E-3407.5997666E-2[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id]NULLPLAN_ROW-11.0
| | | | | |--Table Spool7183174Table SpoolLazy SpoolNULLNULL30.01.6756756E-20.0000055118.9449659E-2[copay].[copay_id]NULLPLAN_ROW-16482.0
| | | | | |--Index Scan(OBJECT:([iscribedb1].[dbo].[copay].[uk_copay]))7184183Index ScanIndex ScanOBJECT:([iscribedb1].[dbo].[copay].[uk_copay])[copay].[copay_id]30.03.7578501E-20.0001115563.7689999E-2[copay].[copay_id]NULLPLAN_ROW-11.0
| | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([copay_drug_label].[copay_id], [copay_drug_label].[drug_label_id]))7185172ParallelismRepartition StreamsPARTITION COLUMNS:([copay_drug_label].[copay_id], [copay_drug_label].[drug_label_id])NULL104862.00.03.49020433884.7966075[copay_drug_label].[drug_label_id], [copay_drug_label].[copay_id], [copay_drug_label].[copay_pharmacy_type], [copay_drug_label].[copay_first_term], [copay_drug_label].[copay_flat_dollar_amount], [copay_drug_label].[copay_percent], [copay_drug_label].[dict_copay_display_id], [copay_drug_label].[copay_min_dollar_amount], [copay_drug_label].[copay_max_dollar_amount], [copay_drug_label].[copay_days_supply], [copay_drug_label].[copay_max_tier], [copay_drug_label].[copay_short], [copay_drug_label].[copay_long]NULLPLAN_ROW-11.0
| | | | |--Clustered Index Scan(OBJECT:([iscribedb1].[dbo].[copay_drug_label].[uk_copay_drug_label_1]))7186185Clustered Index ScanClustered Index ScanOBJECT:([iscribedb1].[dbo].[copay_drug_label].[uk_copay_drug_label_1])[copay_drug_label].[drug_label_id], [copay_drug_label].[copay_id], [copay_drug_label].[copay_pharmacy_type], [copay_drug_label].[copay_first_term], [copay_drug_label].[copay_flat_dollar_amount], [copay_drug_label].[copay_percent], [copay_drug_label].[dict_copay_display_id], [copay_drug_label].[copay_min_dollar_amount], [copay_drug_label].[copay_max_dollar_amount], [copay_drug_label].[copay_days_supply], [copay_drug_label].[copay_max_tier], [copay_drug_label].[copay_short], [copay_drug_label].[copay_long]104862.00.624344832.8856674E-23881.3064029[copay_drug_label].[drug_label_id], [copay_drug_label].[copay_id], [copay_drug_label].[copay_pharmacy_type], [copay_drug_label].[copay_first_term], [copay_drug_label].[copay_flat_dollar_amount], [copay_drug_label].[copay_percent], [copay_drug_label].[dict_copay_display_id], [copay_drug_label].[copay_min_dollar_amount], [copay_drug_label].[copay_max_dollar_amount], [copay_drug_label].[copay_days_supply], [copay_drug_label].[copay_max_tier], [copay_drug_label].[copay_short], [copay_drug_label].[copay_long]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([h].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]))76297ParallelismRepartition StreamsPARTITION COLUMNS:([h].[copay_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL3.0621272E+70.01689.128547813769.303[h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[formulary_id], [c].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Hash Match(Right Outer Join, HASH:([c].[coverage_id], [c].[drug_label_assoc_detail_id])=([h].[coverage_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([h].[coverage_id]=[c].[coverage_id] AND [drug_label_assoc_detail].[drug_label_assoc_detail_id]=[c].[drug_label_assoc_detail_id]))7630629Hash MatchRight Outer JoinHASH:([c].[coverage_id], [c].[drug_label_assoc_detail_id])=([h].[coverage_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([h].[coverage_id]=[c].[coverage_id] AND [drug_label_assoc_detail].[drug_label_assoc_detail_id]=[c].[drug_label_assoc_detail_id])NULL3.0621272E+70.0134.0464947812080.174[h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[formulary_id], [c].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([c].[coverage_id], [c].[drug_label_assoc_detail_id]))7631630ParallelismRepartition StreamsPARTITION COLUMNS:([c].[coverage_id], [c].[drug_label_assoc_detail_id])NULL48046.00.00.19570008390.33233571[c].[coverage_id], [c].[drug_label_assoc_detail_id]NULLPLAN_ROW-11.0
| | | | |--Index Scan(OBJECT:([iscribedb1].[dbo].[coverage_exclusion].[PK_coverage_exclusion] AS [c]))7632631Index ScanIndex ScanOBJECT:([iscribedb1].[dbo].[coverage_exclusion].[PK_coverage_exclusion] AS [c])[c].[coverage_id], [c].[drug_label_assoc_detail_id]48046.00.110171090.02646455390.13663565[c].[coverage_id], [c].[drug_label_assoc_detail_id]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([h].[coverage_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]))7633630ParallelismRepartition StreamsPARTITION COLUMNS:([h].[coverage_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL3.0621272E+70.01689.128547411945.796[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Hash Match(Right Outer Join, HASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary].[default_brand_dict_formulary_display_id]))7634633Hash MatchRight Outer JoinHASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary].[default_brand_dict_formulary_display_id])NULL3.0621272E+70.0103.0257147410256.667[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Parallelism(Distribute Streams, PARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id]))7635634ParallelismDistribute StreamsPARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id])NULL225.00.03.0260062E-2716.9646046E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))7636635Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]225.03.9059982E-23.2600001E-4713.9385982E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW01.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary].[default_brand_dict_formulary_display_id]))7637634ParallelismRepartition StreamsPARTITION COLUMNS:([formulary].[default_brand_dict_formulary_display_id])NULL3.0621272E+70.01530.525642510153.571[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Hash Match(Right Outer Join, HASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary].[default_generic_dict_formulary_display_id]))7638637Hash MatchRight Outer JoinHASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary].[default_generic_dict_formulary_display_id])NULL3.0621272E+70.0156.90444258623.0459[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Parallelism(Distribute Streams, PARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id]))7639638ParallelismDistribute StreamsPARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id])NULL225.00.03.0260062E-2716.9646046E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))7640639Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]225.03.9059982E-23.2600001E-4713.9385982E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW01.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary].[default_generic_dict_formulary_display_id]))7641638ParallelismRepartition StreamsPARTITION COLUMNS:([formulary].[default_generic_dict_formulary_display_id])NULL3.0621272E+70.01380.5123738466.0723[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Hash Match(Right Outer Join, HASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary_drug_label].[dict_formulary_display_id]))7642641Hash MatchRight Outer JoinHASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary_drug_label].[dict_formulary_display_id])NULL3.0621272E+70.0109.805733737085.5601[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Parallelism(Distribute Streams, PARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id]))7643642ParallelismDistribute StreamsPARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id])NULL225.00.03.0260062E-2716.9646046E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))7644643Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]225.03.9059982E-23.2600001E-4713.9385982E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW01.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary_drug_label].[dict_formulary_display_id]))7645642ParallelismRepartition StreamsPARTITION COLUMNS:([formulary_drug_label].[dict_formulary_display_id])NULL3.0621272E+70.01213.59553226975.6846[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Hash Match(Right Outer Join, HASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary_drug_label].[dict_formulary_display_id]))7646645Hash MatchRight Outer JoinHASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary_drug_label].[dict_formulary_display_id])NULL3.0621272E+70.0109.805733225762.0894[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Parallelism(Distribute Streams, PARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id]))7647646ParallelismDistribute StreamsPARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id])NULL225.00.03.0260062E-2716.9646046E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))7648647Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]225.03.9059982E-23.2600001E-4713.9385982E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW01.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary_drug_label].[dict_formulary_display_id]))7649646ParallelismRepartition StreamsPARTITION COLUMNS:([formulary_drug_label].[dict_formulary_display_id])NULL3.0621272E+70.01044.5662765652.2139[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Hash Match(Right Outer Join, HASH:([formulary_drug_label].[formulary_id], [formulary_drug_label].[drug_label_id])=([formulary].[formulary_id], [drug_label].[drug_label_on_patent_brand_id]), RESIDUAL:([formulary_drug_label].[formulary_id]=[formulary].[formulary_id] AND [formulary_drug_label].[drug_label_id]=[drug_label].[drug_label_on_patent_brand_id]))7650649Hash MatchRight Outer JoinHASH:([formulary_drug_label].[formulary_id], [formulary_drug_label].[drug_label_id])=([formulary].[formulary_id], [drug_label].[drug_label_on_patent_brand_id]), RESIDUAL:([formulary_drug_label].[formulary_id]=[formulary].[formulary_id] AND [formulary_drug_label].[drug_label_id]=[drug_label].[drug_label_on_patent_brand_id])NULL3.0621272E+7389.48367177.918912764607.6479[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary_drug_label].[formulary_id], [formulary_drug_label].[drug_label_id]))7651650ParallelismRepartition StreamsPARTITION COLUMNS:([formulary_drug_label].[formulary_id], [formulary_drug_label].[drug_label_id])NULL4104334.00.016.8603744133.842781[formulary_drug_label].[drug_label_id], [formulary_drug_label].[formulary_id], [formulary_drug_label].[dict_formulary_display_id]NULLPLAN_ROW-11.0
| | | | |--Clustered Index Scan(OBJECT:([iscribedb1].[dbo].[formulary_drug_label].[uk_formulary_drug_label_1]))7652651Clustered Index ScanClustered Index ScanOBJECT:([iscribedb1].[dbo].[formulary_drug_label].[uk_formulary_drug_label_1])[formulary_drug_label].[drug_label_id], [formulary_drug_label].[formulary_id], [formulary_drug_label].[dict_formulary_display_id]4104334.014.7249862.25742294116.982409[formulary_drug_label].[drug_label_id], [formulary_drug_label].[formulary_id], [formulary_drug_label].[dict_formulary_display_id]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary].[formulary_id], [drug_label].[drug_label_on_patent_brand_id]))7653650ParallelismRepartition StreamsPARTITION COLUMNS:([formulary].[formulary_id], [drug_label].[drug_label_on_patent_brand_id])NULL3.0621272E+70.01036.25232784006.4023[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Hash Match(Right Outer Join, HASH:([formulary_drug_label].[formulary_id], [formulary_drug_label].[drug_label_id])=([formulary].[formulary_id], [drug_label].[drug_label_id]), RESIDUAL:([formulary_drug_label].[formulary_id]=[formulary].[formulary_id] AND [formulary_drug_label].[drug_label_id]=[drug_label].[drug_label_id]))7654653Hash MatchRight Outer JoinHASH:([formulary_drug_label].[formulary_id], [formulary_drug_label].[drug_label_id])=([formulary].[formulary_id], [drug_label].[drug_label_id]), RESIDUAL:([formulary_drug_label].[formulary_id]=[formulary].[formulary_id] AND [formulary_drug_label].[drug_label_id]=[drug_label].[drug_label_id])NULL3.0621272E+7392.2373177.918912782970.1499[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [formulary_drug_label].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary_drug_label].[formulary_id], [formulary_drug_label].[drug_label_id]))7655654ParallelismRepartition StreamsPARTITION COLUMNS:([formulary_drug_label].[formulary_id], [formulary_drug_label].[drug_label_id])NULL4104334.00.016.8603744133.842781[formulary_drug_label].[drug_label_id], [formulary_drug_label].[formulary_id], [formulary_drug_label].[dict_formulary_display_id]NULLPLAN_ROW-11.0
| | | | |--Clustered Index Scan(OBJECT:([iscribedb1].[dbo].[formulary_drug_label].[uk_formulary_drug_label_1]))7656655Clustered Index ScanClustered Index ScanOBJECT:([iscribedb1].[dbo].[formulary_drug_label].[uk_formulary_drug_label_1])[formulary_drug_label].[drug_label_id], [formulary_drug_label].[formulary_id], [formulary_drug_label].[dict_formulary_display_id]4104334.014.7249862.25742294116.982409[formulary_drug_label].[drug_label_id], [formulary_drug_label].[formulary_id], [formulary_drug_label].[dict_formulary_display_id]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_id]))7657654ParallelismRepartition StreamsPARTITION COLUMNS:([formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_id])NULL3.0621272E+70.01040.4782762366.1511[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Hash Match(Right Outer Join, HASH:([formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id])=([formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([formulary_drug_label_assoc_detail].[formulary_id]=[formulary].[formulary_id] AND [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id]=[drug_label_assoc_detail].[drug_label_assoc_detail_id]))7658657Hash MatchRight Outer JoinHASH:([formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id])=([formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]), RESIDUAL:([formulary_drug_label_assoc_detail].[formulary_id]=[formulary].[formulary_id] AND [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id]=[drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL3.0621272E+70.0143.323872761325.673[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id]))7659658ParallelismRepartition StreamsPARTITION COLUMNS:([formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL361583.00.03.5072901717.6581349[formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id], [formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | |--Hash Match(Right Outer Join, HASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary_drug_label_assoc_detail].[dict_formulary_display_id]))7660659Hash MatchRight Outer JoinHASH:([dict_formulary_display].[dict_formulary_display_id])=([formulary_drug_label_assoc_detail].[dict_formulary_display_id])NULL361583.00.01.16567714.1508446[formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id], [formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | |--Parallelism(Distribute Streams, PARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id]))7661660ParallelismDistribute StreamsPARTITION COLUMNS:([dict_formulary_display].[dict_formulary_display_id])NULL225.00.03.0244537E-2716.9630519E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))7662661Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]225.03.9059982E-23.2600001E-4713.9385982E-2[dict_formulary_display].[dict_formulary_display_id], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW01.0
| | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary_drug_label_assoc_detail].[dict_formulary_display_id]))7663660ParallelismRepartition StreamsPARTITION COLUMNS:([formulary_drug_label_assoc_detail].[dict_formulary_display_id])NULL361583.00.01.3849787412.9155412[formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id], [formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[dict_formulary_display_id]NULLPLAN_ROW-11.0
| | | | |--Clustered Index Scan(OBJECT:([iscribedb1].[dbo].[formulary_drug_label_assoc_detail].[uk_formulary_drug_label_assoc_detail]))7664663Clustered Index ScanClustered Index ScanOBJECT:([iscribedb1].[dbo].[formulary_drug_label_assoc_detail].[uk_formulary_drug_label_assoc_detail])[formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id], [formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[dict_formulary_display_id]361583.01.33165250.19890989411.5305625[formulary_drug_label_assoc_detail].[drug_label_assoc_detail_id], [formulary_drug_label_assoc_detail].[formulary_id], [formulary_drug_label_assoc_detail].[dict_formulary_display_id]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id]))7666658ParallelismRepartition StreamsPARTITION COLUMNS:([formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id])NULL3.0621272E+70.0854.545722201174.6909[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Hash Match(Inner Join, HASH:([h].[formulary_id])=([formulary].[formulary_id]))7667666Hash MatchInner JoinHASH:([h].[formulary_id])=([formulary].[formulary_id])NULL3.0621272E+70.051.702042220320.1452[h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code], [formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([h].[formulary_id]))7668667ParallelismRepartition StreamsPARTITION COLUMNS:([h].[formulary_id])NULL5834.00.08.3972588E-2840.19591016[h].[formulary_id], [h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code]NULLPLAN_ROW-11.0
| | | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[health_care_plan] AS [h]))7669668Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[health_care_plan] AS [h])[h].[formulary_id], [h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code]5834.00.108689610.00324795840.11193756[h].[formulary_id], [h].[coverage_id], [h].[copay_id], [h].[health_care_plan_id], [h].[health_care_plan_name], [h].[health_care_plan_dataload_source_code]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([formulary].[formulary_id]))7670667ParallelismRepartition StreamsPARTITION COLUMNS:([formulary].[formulary_id])NULL1.1553689E+70.0239.8311165268.24725[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | |--Nested Loops(Inner Join)7671670Nested LoopsInner JoinNULLNULL1.1553689E+70.024.14721116528.416157[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id], [drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NO JOIN PREDICATEPLAN_ROW-11.0
| | | |--Nested Loops(Inner Join)7672671Nested LoopsInner JoinNULLNULL6231.76320.01.3024385E-21572.1052403[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc], [dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | |--Parallelism(Broadcast)7673672ParallelismBroadcastNULLNULL1.00.02.8506704E-2713.1839658E-2[dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | | | | |--Bookmark Lookup(BOOKMARK:([Bmk1036]), OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))7674673Bookmark LookupBookmark LookupBOOKMARK:([Bmk1036]), OBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]1.04.8826954E-50.0000011713.3329551E-3[dict_formulary_display].[dict_formulary_display_desc], [dict_formulary_display].[dict_formulary_display_rank_nbr], [dict_formulary_display].[dict_copay_display_id], [dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW01.0
| | | | | |--Index Seek(OBJECT:([iscribedb1].[dbo].[dict_formulary_display].[uk_dict_formulary_display_old_code]), SEEK:([dict_formulary_display].[dict_formulary_display_old_code]='U') ORDERED FORWARD)7675674Index SeekIndex SeekOBJECT:([iscribedb1].[dbo].[dict_formulary_display].[uk_dict_formulary_display_old_code]), SEEK:([dict_formulary_display].[dict_formulary_display_old_code]='U') ORDERED FORWARD[Bmk1036]1.03.2034251E-37.9603E-5183.283028E-3[Bmk1036]NULLPLAN_ROW01.0
| | | | |--Hash Match(Inner Join, HASH:([dict_drug_route].[dict_drug_route_id])=([drug_detail].[dict_drug_route_id]))7676672Hash MatchInner JoinHASH:([dict_drug_route].[dict_drug_route_id])=([drug_detail].[dict_drug_route_id])NULL6231.76320.04.7478884E-2942.0603762[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str], [dict_drug_route].[dict_drug_route_desc]NULLPLAN_ROW-11.0
| | | | |--Parallelism(Broadcast)7677676ParallelismBroadcastNULLNULL38.00.00.02862101486.6319808E-2[dict_drug_route].[dict_drug_route_id], [dict_drug_route].[dict_drug_route_desc]NULLPLAN_ROW-11.0
| | | | | |--Index Scan(OBJECT:([iscribedb1].[dbo].[dict_drug_route].[pk_dict_drug_route]))7678677Index ScanIndex ScanOBJECT:([iscribedb1].[dbo].[dict_drug_route].[pk_dict_drug_route])[dict_drug_route].[dict_drug_route_id], [dict_drug_route].[dict_drug_route_desc]38.03.7578501E-20.0001203483.7698802E-2[dict_drug_route].[dict_drug_route_id], [dict_drug_route].[dict_drug_route_desc]NULLPLAN_ROW01.0
| | | | |--Hash Match(Inner Join, HASH:([drug_label_assoc_detail].[drug_label_id])=([drug_label].[drug_label_id]))7679676Hash MatchInner JoinHASH:([drug_label_assoc_detail].[drug_label_id])=([drug_label].[drug_label_id])NULL6395.96580.00.17962061801.9465746[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_label].[drug_label_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code], [drug_detail].[dict_drug_route_id], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str]NULLPLAN_ROW-11.0
| | | | |--Bitmap(HASH:([drug_label_assoc_detail].[drug_label_id]), DEFINE:([Bitmap1485]))7680679BitmapBitmap CreateHASH:([drug_label_assoc_detail].[drug_label_id])[Bitmap1485]6395.96580.08.4020182E-2571.4015372[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_detail].[dict_drug_route_id], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str]NULLPLAN_ROW-11.0
Parallelism(Repartition Streams, PARTITION COLUMNS:([drug_label_assoc_detail].[drug_label_id]))7681680ParallelismRepartition StreamsPARTITION COLUMNS:([drug_label_assoc_detail].[drug_label_id])NULL6395.96580.08.4020182E-2571.4015372[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_detail].[dict_drug_route_id], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str]NULLPLAN_ROW-11.0
Hash Match(Inner Join, HASH:([dict_drug_form].[dict_drug_form_id])=([drug_detail].[dict_drug_form_id]))7682681Hash MatchInner JoinHASH:([dict_drug_form].[dict_drug_form_id])=([drug_detail].[dict_drug_form_id])NULL6395.96580.04.2181056E-2571.3175169[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_detail].[dict_drug_route_id], [dict_drug_form].[dict_drug_form_desc], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str]NULLPLAN_ROW-11.0
|--Parallelism(Distribute Streams, PARTITION COLUMNS:([dict_drug_form].[dict_drug_form_id]))7683682ParallelismDistribute StreamsPARTITION COLUMNS:([dict_drug_form].[dict_drug_form_id])NULL155.00.02.9049398E-2306.6876896E-2[dict_drug_form].[dict_drug_form_id], [dict_drug_form].[dict_drug_form_desc]NULLPLAN_ROW-11.0
| |--Table Scan(OBJECT:([iscribedb1].[dbo].[dict_drug_form]))7684683Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[dict_drug_form])[dict_drug_form].[dict_drug_form_id], [dict_drug_form].[dict_drug_form_desc]155.03.7578501E-20.000249303.7827499E-2[dict_drug_form].[dict_drug_form_id], [dict_drug_form].[dict_drug_form_desc]NULLPLAN_ROW01.0
|--Parallelism(Repartition Streams, PARTITION COLUMNS:([drug_detail].[dict_drug_form_id]))7685682ParallelismRepartition StreamsPARTITION COLUMNS:([drug_detail].[dict_drug_form_id])NULL6479.69870.08.0528744E-2531.208456[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_detail].[dict_drug_form_id], [drug_detail].[dict_drug_route_id], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str]NULLPLAN_ROW-11.0
|--Hash Match(Inner Join, HASH:([dict_drug_strength_unit].[dict_drug_strength_unit_id])=([dict_drug_strength].[dict_drug_strength_unit_id]))7686685Hash MatchInner JoinHASH:([dict_drug_strength_unit].[dict_drug_strength_unit_id])=([dict_drug_strength].[dict_drug_strength_unit_id])NULL6479.69870.04.5943025E-2531.1279273[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_detail].[dict_drug_form_id], [drug_detail].[dict_drug_route_id], [dict_drug_strength].[dict_drug_strength_qnty_str], [dict_drug_strength_unit].[dict_drug_strength_unit_str]NULLPLAN_ROW-11.0
|--Parallelism(Repartition Streams, PARTITION COLUMNS:([dict_drug_strength_unit].[dict_drug_strength_unit_id]))7687686ParallelismRepartition StreamsPARTITION COLUMNS:([dict_drug_strength_unit].[dict_drug_strength_unit_id])NULL890.00.03.1804126E-2387.1392857E-2[dict_drug_strength_unit].[dict_drug_strength_unit_id], [dict_drug_strength_unit].[dict_drug_strength_unit_str]NULLPLAN_ROW-11.0
| |--Index Scan(OBJECT:([iscribedb1].[dbo].[dict_drug_strength_unit].[IX_dict_drug_strength_unit]))7688687Index ScanIndex ScanOBJECT:([iscribedb1].[dbo].[dict_drug_strength_unit].[IX_dict_drug_strength_unit])[dict_drug_strength_unit].[dict_drug_strength_unit_id], [dict_drug_strength_unit].[dict_drug_strength_unit_str]890.03.9059982E-25.2875001E-4383.9588731E-2[dict_drug_strength_unit].[dict_drug_strength_unit_id], [dict_drug_strength_unit].[dict_drug_strength_unit_str]NULLPLAN_ROW-11.0
|--Parallelism(Repartition Streams, PARTITION COLUMNS:([dict_drug_strength].[dict_drug_strength_unit_id]))7689686ParallelismRepartition StreamsPARTITION COLUMNS:([dict_drug_strength].[dict_drug_strength_unit_id])NULL6481.83110.07.8951336E-2441.0105884[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_detail].[dict_drug_form_id], [drug_detail].[dict_drug_route_id], [dict_drug_strength].[dict_drug_strength_unit_id], [dict_drug_strength].[dict_drug_strength_qnty_str]NULLPLAN_ROW-11.0
|--Hash Match(Inner Join, HASH:([drug_detail].[dict_drug_strength_id])=([dict_drug_strength].[dict_drug_strength_id]))7690689Hash MatchInner JoinHASH:([drug_detail].[dict_drug_strength_id])=([dict_drug_strength].[dict_drug_strength_id])NULL6481.83110.00.1066571440.93163705[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_detail].[dict_drug_form_id], [drug_detail].[dict_drug_route_id], [dict_drug_strength].[dict_drug_strength_unit_id], [dict_drug_strength].[dict_drug_strength_qnty_str]NULLPLAN_ROW-11.0
| |--Parallelism(Repartition Streams, PARTITION COLUMNS:([drug_detail].[dict_drug_strength_id]))7691690ParallelismRepartition StreamsPARTITION COLUMNS:([drug_detail].[dict_drug_strength_id])NULL6481.85690.06.9364868E-2300.69177514[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_detail].[dict_drug_form_id], [drug_detail].[dict_drug_strength_id], [drug_detail].[dict_drug_route_id]NULLPLAN_ROW-11.0
| | |--Hash Match(Inner Join, HASH:([drug_label_assoc_detail].[drug_detail_id])=([drug_detail].[drug_detail_id]))7692691Hash MatchInner JoinHASH:([drug_label_assoc_detail].[drug_detail_id])=([drug_detail].[drug_detail_id])NULL6481.85690.00.12674837300.6224103[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag], [drug_detail].[dict_drug_form_id], [drug_detail].[dict_drug_strength_id], [drug_detail].[dict_drug_route_id]NULLPLAN_ROW-11.0
| | | |--Bitmap(HASH:([drug_label_assoc_detail].[drug_detail_id]), DEFINE:([Bitmap1484]))7693692BitmapBitmap CreateHASH:([drug_label_assoc_detail].[drug_detail_id])[Bitmap1484]6482.00.00.05793152400.13392919[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag]NULLPLAN_ROW-11.0
| | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([drug_label_assoc_detail].[drug_detail_id]))7694693ParallelismRepartition StreamsPARTITION COLUMNS:([drug_label_assoc_detail].[drug_detail_id])NULL6482.00.00.05793152400.13392919[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag]NULLPLAN_ROW-11.0
| | | | |--Clustered Index Scan(OBJECT:([iscribedb1].[dbo].[drug_label_assoc_detail].[uk_drug_label_assoc_detail_1]))7695694Clustered Index ScanClustered Index ScanOBJECT:([iscribedb1].[dbo].[drug_label_assoc_detail].[uk_drug_label_assoc_detail_1])[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag]6482.07.2393313E-23.6043499E-3407.5997666E-2[drug_label_assoc_detail].[drug_label_assoc_detail_id], [drug_label_assoc_detail].[drug_label_id], [drug_label_assoc_detail].[drug_detail_id], [drug_label_assoc_detail].[drug_label_assoc_detail_otc_flag]NULLPLAN_ROW-11.0
| | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([drug_detail].[drug_detail_id]), WHERE:(PROBE([Bitmap1484])=TRUE))7696692ParallelismRepartition StreamsPARTITION COLUMNS:([drug_detail].[drug_detail_id]), WHERE:(PROBE([Bitmap1484])=TRUE)NULL23674.00.00.13109128250.36172974[drug_detail].[drug_detail_id], [drug_detail].[dict_drug_form_id], [drug_detail].[dict_drug_strength_id], [drug_detail].[dict_drug_route_id]NULLPLAN_ROW-11.0
| | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[drug_detail]))7697696Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[drug_detail])[drug_detail].[drug_detail_id], [drug_detail].[dict_drug_form_id], [drug_detail].[dict_drug_strength_id], [drug_detail].[dict_drug_route_id]23674.00.21757850.01305995250.23063844[drug_detail].[drug_detail_id], [drug_detail].[dict_drug_form_id], [drug_detail].[dict_drug_strength_id], [drug_detail].[dict_drug_route_id]NULLPLAN_ROW-11.0
| |--Parallelism(Repartition Streams, PARTITION COLUMNS:([dict_drug_strength].[dict_drug_strength_id]))7699690ParallelismRepartition StreamsPARTITION COLUMNS:([dict_drug_strength].[dict_drug_strength_id])NULL7209.00.00.05902651300.13320181[dict_drug_strength].[dict_drug_strength_id], [dict_drug_strength].[dict_drug_strength_unit_id], [dict_drug_strength].[dict_drug_strength_qnty_str]NULLPLAN_ROW-11.0
| | |--Table Scan(OBJECT:([iscribedb1].[dbo].[dict_drug_strength]))7700699Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[dict_drug_strength])[dict_drug_strength].[dict_drug_strength_id], [dict_drug_strength].[dict_drug_strength_unit_id], [dict_drug_strength].[dict_drug_strength_qnty_str]7209.07.0171095E-20.0040042307.4175291E-2[dict_drug_strength].[dict_drug_strength_id], [dict_drug_strength].[dict_drug_strength_unit_id], [dict_drug_strength].[dict_drug_strength_qnty_str]NULLPLAN_ROW-11.0
| | | | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([drug_label].[drug_label_id]), WHERE:(PROBE([Bitmap1485])=TRUE))7704679ParallelismRepartition StreamsPARTITION COLUMNS:([drug_label].[drug_label_id]), WHERE:(PROBE([Bitmap1485])=TRUE)NULL31336.00.00.20537606670.36541378[drug_label].[drug_label_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code]NULLPLAN_ROW-11.0
Index Scan(OBJECT:([iscribedb1].[dbo].[drug_label].[ix_drug_label_1]))7705704Index ScanIndex ScanOBJECT:([iscribedb1].[dbo].[drug_label].[ix_drug_label_1])[drug_label].[drug_label_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code]31336.00.142763690.01727405670.16003774[drug_label].[drug_label_id], [drug_label].[drug_label_name], [drug_label].[drug_label_on_patent_brand_id], [drug_label].[drug_label_type_code]NULLPLAN_ROW-11.0
| | | |--Table Spool7708671Table SpoolLazy SpoolNULLNULL1854.03.0270271E-23.3402001E-4152.1637051[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id]NULLPLAN_ROW-16231.7632
| | | |--Table Scan(OBJECT:([iscribedb1].[dbo].[formulary]))7709708Table ScanTable ScanOBJECT:([iscribedb1].[dbo].[formulary])[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id]1854.02.5826287E-20.00105895235.3770475E-2[formulary].[default_generic_dict_formulary_display_id], [formulary].[default_brand_dict_formulary_display_id], [formulary].[formulary_id]NULLPLAN_ROW-11.0
| | |--Table Spool77206Table SpoolLazy SpoolNULLNULL1.01.6756756E-22.7999999E-7145.531919[dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-13.0621272E+7
| | |--Bookmark Lookup(BOOKMARK:([Bmk1141]), OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))7721720Bookmark LookupBookmark LookupBOOKMARK:([Bmk1141]), OBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_code]1.04.8826954E-50.0000011713.3329551E-3[dict_formulary_display].[dict_formulary_display_code]NULLPLAN_ROW-11.0
| | |--Index Seek(OBJECT:([iscribedb1].[dbo].[dict_formulary_display].[pk_dict_formulary_display]), SEEK:([dict_formulary_display].[dict_formulary_display_id]=28) ORDERED FORWARD)7722721Index SeekIndex SeekOBJECT:([iscribedb1].[dbo].[dict_formulary_display].[pk_dict_formulary_display]), SEEK:([dict_formulary_display].[dict_formulary_display_id]=28) ORDERED FORWARD[Bmk1141]1.03.2034251E-37.9603E-5173.283028E-3[Bmk1141]NULLPLAN_ROW-11.0
| |--Table Spool77235Table SpoolLazy SpoolNULLNULL1.01.6756756E-22.7999999E-7515.531919[dict_formulary_display].[dict_formulary_display_desc]NULLPLAN_ROW-13.0621272E+7
| |--Bookmark Lookup(BOOKMARK:([Bmk1145]), OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))7724723Bookmark LookupBookmark LookupBOOKMARK:([Bmk1145]), OBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_desc]1.04.8826954E-50.0000011713.3329551E-3[dict_formulary_display].[dict_formulary_display_desc]NULLPLAN_ROW-11.0
| |--Index Seek(OBJECT:([iscribedb1].[dbo].[dict_formulary_display].[pk_dict_formulary_display]), SEEK:([dict_formulary_display].[dict_formulary_display_id]=28) ORDERED FORWARD)7725724Index SeekIndex SeekOBJECT:([iscribedb1].[dbo].[dict_formulary_display].[pk_dict_formulary_display]), SEEK:([dict_formulary_display].[dict_formulary_display_id]=28) ORDERED FORWARD[Bmk1145]1.03.2034251E-37.9603E-5173.283028E-3[Bmk1145]NULLPLAN_ROW-11.0
|--Table Spool77264Table SpoolLazy SpoolNULLNULL1.01.6756756E-22.7999999E-795.531919[dict_formulary_display].[dict_formulary_display_rank_nbr]NULLPLAN_ROW-13.0621272E+7
|--Bookmark Lookup(BOOKMARK:([Bmk1149]), OBJECT:([iscribedb1].[dbo].[dict_formulary_display]))7727726Bookmark LookupBookmark LookupBOOKMARK:([Bmk1149]), OBJECT:([iscribedb1].[dbo].[dict_formulary_display])[dict_formulary_display].[dict_formulary_display_rank_nbr]1.04.8826954E-50.0000011713.3329551E-3[dict_formulary_display].[dict_formulary_display_rank_nbr]NULLPLAN_ROW-11.0
|--Index Seek(OBJECT:([iscribedb1].[dbo].[dict_formulary_display].[pk_dict_formulary_display]), SEEK:([dict_formulary_display].[dict_formulary_display_id]=28) ORDERED FORWARD)7728727Index SeekIndex SeekOBJECT:([iscribedb1].[dbo].[dict_formulary_display].[pk_dict_formulary_display]), SEEK:([dict_formulary_display].[dict_formulary_display_id]=28) ORDERED FORWARD[Bmk1149]1.03.2034251E-37.9603E-5173.283028E-3[Bmk1149]NULLPLAN_ROW-11.0

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Let me be the first to suggest you to save the execution plan in a .sql file, zip it and attach if to your post. Noone's going to read all that and even try to answer that!

1 quick question... why do you think this report is slow?.. compared to what?