Total Pageviews

August 23, 2015

8/23/2015 12:30:00 AM
TOAD Explain Plan
                                               Oracle Tuning-Explain Plan Utility

Toad has given Utility to set explain plan

      View->Options

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...