Yes I can add indexes, but I am confused where to add them.

Regards,

Virendra

Indexes are already there on the table and stats are from yesterday.

We drop-create indexes daily as a batch cycle process. My question is it should pick the HASH JOIN instead...

Standard Edition, will take a look tomorrow.

Thanks for your time.

Regards,

Virendra

Supposing that it is same, I have created plan guide and implemented it in database. User will come tomorrow test the report. I am not sure if takes any input....

Query cannot be modified as it is being generated from third patry tool.

Regards,

Virendra

Hey JonFox,

Query without hint never completes and I cannot send actual plan for that for other it is being attahced againg. Yes the reports is displaying 27910 rows to be...

Plans are attached.

Regards,

Virendra