Performance Problem

Hello there
I have sql server database. In there i have two tables with indexes. When i
run simple select between these two tables i get hash join in the execution
plan.
The reason of the hash join is a result of selecting the wrong indexes on
the execution plan.
Whay it use the wrong index? and how can i force it to select the write
index?
any help would be usefulCan you give us the select query that you are using?|||WOudl be easier with an execution plan, ddl or the Select to encounter the
problem.
HTH, Jens Smeyer
http://www.sqlserver2005.de
--
"Roy Goldhammer" <roygoldh@.hotmail.com> schrieb im Newsbeitrag
news:e$9DEO%23QFHA.2356@.TK2MSFTNGP14.phx.gbl...
> Hello there
> I have sql server database. In there i have two tables with indexes. When
> i
> run simple select between these two tables i get hash join in the
> execution
> plan.
> The reason of the hash join is a result of selecting the wrong indexes on
> the execution plan.
> Whay it use the wrong index? and how can i force it to select the write
> index?
> any help would be useful
>
>