Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How do we accept inputs from user during runtime?

1040


What is a relationship and what are they?

1120


What are the two characteristics of a primary key?

958


What is rank () in sql?

923


define join and explain different type of joins? : Sql dba

929


Can ddl statements be used in pl/sql?

1116


What is a boolean in sql?

965


Is sql a dbms?

976


Differentiate between pl/sql and sql?

1123


What operators deal with null?

1083


Can we use the cursor's to create the collection in PL/SQL?

1001


what are wild cards used in database for pattern matching ? : Sql dba

1113


What are types of indexes in sql?

1059


What is group function in sql?

1000


What do you mean by rowid?

950