You can enable and disable merge joins at the server and session level using set sort_merge, or at the server level with the configuration parameter enable sort-merge joins and JTC. This configuration parameter also enables and disables join transitive closure.
