Re: SQL Query tuning using TOAD
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Mon, 26 Oct 2015 12:05:23 +0000
Message-ID: <562E1703.1000406_at_dunbar-it.co.uk>
Morning Ashoke,
Date: Mon, 26 Oct 2015 12:05:23 +0000
Message-ID: <562E1703.1000406_at_dunbar-it.co.uk>
Morning Ashoke,
On 22/10/15 17:27, Mandal, Ashoke wrote:
> I was under impression that we could tune a SQL query using TOAD but I
> am not able see any option. Does anyone have any idea?
The following assumes Toad version 12.
In the editor, highlight the SQL statement you want to optimise and right click. Select Optimise (with a z), then select one of the three options - for advanced SQL Optimisation, you will need the SQL Optimiser module licence.
You can also get at these options from the Database->Optimise (with a z) menu.
HTH
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: 27a Lidget Hill Pudsey West Yorkshire United Kingdom LS28 7LG Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 26 2015 - 13:05:23 CET