what is explain plan?

Answer Posted / sureshkumar.somayajula

Explain Plan determines the execution plan for SQL
Statements.

Syntax:

expalin paln
set statement_id= ' Text '
schemaname.Table_name@Databaselink
for Statement.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is your daily office routine?

1776


How can use stored procedures in sql?

549


How to run sql statements through the web interface?

489


what are the advantages of mysql in comparison to oracle? : Sql dba

500


What is union and union all keyword in sql?

543






When are we going to use truncate and delete?

525


How do I view an execution plan in sql?

510


What is the location of pre_defined_functions.

619


Can we use commit inside a trigger?

501


What is sql profiler in oracle?

535


What is dialect in sql?

509


What is an exception in pl/sql?

520


Can you load data into multiple tables at once? : aql loader

571


How do you respond to dementia behavior?

512


What are types of joins?

516