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 / b.v.srinivas

Explian plan describes the effective way to process sql
statement.
Explain plan is generated by Optimizer.
And explain plan is stored in library cache.

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 foreign key? : Sql dba

1048


what does the t-sql command ident_incr does? : Transact sql

1077


Mention what are different methods to trace the pl/sql code?

1205


Why indexing is needed?

984


What are analytic functions in sql?

1025


what is the difference between nested subquery and correlated subquery?

1054


What is secondary key?

934


How do you use collections in procedure to return the resultset?

2238


Can we rollback delete command?

985


what is the difference between a having clause and a where clause? : Sql dba

1087


What is data control language?

990


How can I see all tables in sql?

1077


Is sql port 1433 encrypted?

1023


What is the difference between sql and mysql?

1117


what are the differences among rownum, rank and dense_rank? : Sql dba

1040