To enable merge joins for a session, use:
set sort_merge on
To disable merge joins during a session, use:
set sort_merge off
The session setting has precedence over the server-wide setting; you can use merge joins in a session or stored procedure even if they are disabled at the server-wide level.
