When trying to get indexes for the following query:
After a few seconds the tool still says '0 indexes found so far', then shortly followed by the following message:
"An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name."
Prompted to generate a Support Bundle; clicking Yes causes the tool to crash with the following message:
"Quest SQL Optimizer for SQL Server has stopped working".
Clicking No on the Support Bundle will close the dialog prompt but still do not get any results.
WORKAROUND:
Comment out the INTO clause before optimizing to get index suggestions. For example:
Then the SQL Optimizer will be able to generate index suggestions.
STATUS:
Waiting for a fix in a future release of SQL Optimizer for SQL Server.