If you execute Run Result from within the SQL Editor pane in the SQL Optimizer window, two types of action - commit or rollback - can be made after the Run Result is executed. In this case, you are prompted to commit or rollback for UPDATE, INSERT, DELETE and SELECT INTO SQL statements.
For the optimized SQL, all records affected by the UPDATE, INSERT, DELETE, and SELECT INTO SQL statements are rolled back automatically.
You must logon with sa to terminate SQL statements with a result set, i.e., SELECT SQL statements. Run Result for SQL statements without result set (for example: INSERT, UPDATE, DELETE and SELECT with INTO clause) can be terminated by any logon account.
To terminate the Run Result process
After optimization, the SQL Comparer window provides a way for you to easily compare two SQL statements, query plans, statistics, and abstract plan between the original SQL and optimized alternative SQL statements.