hi

can anyone tell me in what situation you should force a hash join or merge
join option in a query?
When it gives you better performance than the plan the optimizer choose, and
when you have done everything possible to encourage the optimizer to find
the best plan on its own, like building better indexes.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Britney" <britneychen_2001@.yahoo.com> wrote in message
news:ukZYFz1HFHA.1172@.TK2MSFTNGP12.phx.gbl...
> can anyone tell me in what situation you should force a hash join or merge
> join option in a query?
>
>
|||Or updating your statistics with
EXEC sp_updatestats
However, make sure the actual execution is better than the plan offerred by
the Optimizer, not just the estimated plan.
Sincerely,
Anthony Thomas

"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:u8iL$51HFHA.1396@.TK2MSFTNGP10.phx.gbl...
When it gives you better performance than the plan the optimizer choose, and
when you have done everything possible to encourage the optimizer to find
the best plan on its own, like building better indexes.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Britney" <britneychen_2001@.yahoo.com> wrote in message
news:ukZYFz1HFHA.1172@.TK2MSFTNGP12.phx.gbl...
> can anyone tell me in what situation you should force a hash join or merge
> join option in a query?
>
>