Tried several times to optimize a query of mine. It would generate about 30+ alternate queries, but would crash while executing one of them. The following error shows.
The following unhandled error has occurred:
Exception happens at
Class : TComThread
Method : AddAlternativeToScenarios
Module : LabAutoOptimize
Message : Failed to update scenario data file
TIniFN.ReadSection - Exception failure, Error Message - Out of memory
Upgrade to latest version of SQL Optimizer. You can download the latest version at https://support.quest.com/SUPPORT/index?page=downloads.