I am running into a slight problem of restoring a session. I have a big select statment that i am trying to tune and it is take very long time(over 8+ hours). But here is the deal. As normal we have a 8 hour day work...when i come in i start the optimize thing and at the end of the day it comes to about 70% progress bar...so obviously when i go home i cant leave my laptop here...so i have to shut everything down...and have to close quest optimizer...and when i close it gives option to save the work...and it click on "yes" and it creates a file called sessiondata.sts. The next day when i come back to work...i login to optimizer and click on restore session and give the filename and path name...it picks up the sql...but start all over again....i thought it might start where it left of at 70%, but seems like it dont...is there any setting on that or that just a default behaviour(to start optimization all over again instead of where i left and saved my session). THANKS AGAIN IN ADVANCE
Also another question i had is, when we do get the alernative generated. in the compare senerios section. The original
sql stays in Black color and the Alt ## has black and different color. I understand the color are teh changes made
to the sql. But i normally see Blue and Red color. What exactly do they both mean ?
red color represents what and blue represent what?
SORRY IF ITS A STUPID QUESTION…
Message was edited by: crazy