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?

Answer Posted / sadiq afroze

EXPLAIN is used to display the access path as determined by
the optimizer for a SQL statement. It can be used in SPUFI
(for single SQL statement) or in BIND step (for embedded
SQL). The results of EXPLAIN is stored in U.PLAN_TABLE
where U is the authorization id of the user

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I delete a column in db2?

1049


How to find schema of a table in db2?

951


List out the data types available.

1081


What is the max length of sqlca?

1157


What is the latest version of ibm db2?

1201


What is difference between isnull and coalesce?

1007


What is rct?

1164


What is an instance in db2?

983


How to rename a table in DB2 ?

1030


what is the responsibility of the construction superintendent

2079


What is iseries database?

990


Is db2 free?

1036


What is the function of logging in the db2 database?

1069


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1180


What is drop table?

959