I would like to ask if there is a way to set the optimization level for SQL Server like it can be done on DB2/Sybase ASE/Oracle. The reason for this question is that I belive that SQL Server may not be choosing hash join for some cases.
Examples for other DBMS:
Sybase ASE - SELECT @@optlevel
Oracle - PLSQL_OPTIMIZE_LEVEL
