Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2010-11-25 : 04:12:32
|
| hello everybody,could anybody suggest me that using hash joins is a good practice?if yes then in what scenarios should i use them.thanx in advance |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-11-25 : 06:44:23
|
| GilaMonster (Gail Shaw) has an excellent write up on the join operations:http://sqlinthewild.co.za/index.php/2009/11/24/the-most-optimal-join-type/It's still best to avoid using hints unless and until you test them thoroughly and can prove they perform best. Even then they should be reviewed and retested regularly to accommodate data changes that may affect performance. |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-25 : 08:04:20
|
| thanx rob |
|
|
|
|
|
|
HASH JOINS