I had optimized a SQL in the SQL Optimizer window, but I there is no better alternatives. Is there any settings I can change to give me some alternatives?
You can generate more alternatives by changing the Optimization Settings in the preferences. There are two ways you can do this. The easiest way is to change the Intelligence Level to a higher value. The higher Intelligence Level will select more of the Optimization Settings and raise the quotas which enables the SQL optimization process to try more techniques to transform the SQL statement. You can also switch from using the predefined Intelligence Levels to selecting the specific Optimization Settings that you would like to use.