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

Chat now with support

Return

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.

Sign In Required

You need to be signed in and under a current maintenance contract to view premium knowledge articles.

Recommended Content

Product(s):: SQL Optimizer for SQL Server
10.0, 9.5, 9.0; Toad for SQL Server
4.6, 4.5, 4.1.0.226, 4.0.0.835, 3.2.0.325, 3.1.0.1052, 3.0.0.736, 2.0.3.848, 2.0.2.748, 2.0.2, 2.0.1, 2.0.0, 1.0.3, 1.0.1, 1.0.0.683; SQL Optimizer for Oracle
9.2.3, 9.2.2, 9.2.1, 9.2, 9.1, 9.0, 8.9.1, 8.9, 7.5.1, 7.5, 7.4.1, 7.4.0, 7.3.0, 7.2.0, 7.0.0, 3.8.5, 3.8.2, 3.8.0; Toad for Oracle
10.1, 10.0, 9.7.2, 9.7.0, 9.6.1, 9.6.0, 9.5.0, 9.1.0, 9.0.1, 9.0.0, 8.6.1, 8.6.0.38, 8.5.3.2, 8.5.1.6, 7.5.4.17, 8.5.0.50, 7.5.3.57, 8.0.0.47, 7.6.0.1, 7.5.2.0, 7.5, 7.4.0.3, 7.4.0.1, 7.3, 7.2, 7.1, 7.0, 6.4.0.0, 6.5.0.0, 6.3.0.0