SQL Optimizer takes a long time, or does not provide alternative SQL statements. (4303463)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SQL Optimizer takes a long time, or does not provide alternative SQL statements.
Description

After the query is submitted to the SQL Optimizer to be optimized, the SQL Optimizer takes a long time or seems to hang while working to return alternative queries.
Resolution

The intelligence level of SQL Optimizer maybe set too high. Try lowering it in order for SQL Optimizer to apply less hints and permutations on SQL statement.
Consider splitting the rewrite and alternatives execution operations in 2. i.e. Instead of using Auto-optimize, run rewrite first (tuning fork) and then click Test Run. Test Run can be further split by doing Test Run - Selected.
Instead of using the default settings for the Test Run, you can customize the settings by clicking on the link bottom left.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title