Avoiding hash Match by using covering index on object2.index2
For the attached plan, takes around 50 minutes to complete for very simple statement.
yes, the amount of records it is fteching is quite large but is there a way i can improve the plan to run little faster.
Action taken: To avoid index scan i added the covering index (in the included column) for column1 in index2 of object2, but still it scans, not sure what could have possibly be wrong as i expect it to seek.
create index ix_Object1_Column1Column3_inc on Object1 (Column1, Column3) include (column4);
create index ix_Object2_Column2 on Object2 (Column2);