RE: SQL*Optimizer

Hi Mike,

SQL Optimizer's optimization engine is a client-side process and so wouldn't be able to run on the server. This also applies to the Batch SQL operations. A simple solution would be to run SQL Optimizer directly on the Oracle server and use Scan SQL to identify the SQL prior to optimization.

However, I will take your suggestion to the SQL Optimizer development team and see if this is feasible.

Thanks you.

John

From: [email protected] [mailto:[email protected]] On Behalf Of MCALLISTER, MICHAEL CTR AU Contractor AETC AETC/A3IS
Sent: 01 February 2012 01:58
To: [email protected]
Subject: [toad] SQL*Optimizer



All

As far as I know, when evaluating various versions of a SQL statement within SQL*Optimizer, you need to leave your computer running. What would be awesome would be if there was a way for SQL*Optimizer to submit the optimizing task to Oracle instance as a job, and record the results in a TOAD table of some sort that the client could read back the results of later. Is this possible?

Mike