Was able to Optimize and execute alternatives for a complex query successfully. However, when trying to produce a report the following error occurred:
"Quest.Tuning.SQLSvr.Main has encountered a problem and needs to close" followed by
"Runtime error 216"
Steps leading up to error:
Memory issue due to many alternatives with long execution plans.
WORKAROUND
none
STATUS
Waiting for fix in a future release of SQL Optimizer for SQL Server