Total Pageviews

August 23, 2015

8/23/2015 01:00:00 PM
TOAD Explain Plan
                                               Oracle Tuning-Explain Plan Utility

Toad has given Utility to set explain plan


TOAD Explain Plan1

Select Oracle > General

Give explain table name as --- PLAN_TABLE
And Clear the User name for Explain plan column

Press OK

TOAD Explain Plan2

Now fire a query and select explain plan TAB…Now you  can find the Cost of the query

TOAD Explain Plan

Related Posts Plugin for WordPress, Blogger...