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

Explain the EXPLAIN statement?

Answer Posted / s

EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why cursor is used in db2?

1036


How to check last update on table in db2?

1059


What is the difference between cursor and select statement?

1100


What is a bind card?

1216


What is coalesce in db2?

1134


What is cursor with hold option in db2?

1070


What is the use of runstats in db2?

1108


What is runstats db2?

1035


How does coalesce work?

1019


What are the rules for db2 programming?

1087


What is the maximum size of varchar data type in db2?

1133


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8286


What is the difference between dbm cfg and db cfg file in db2 ?

1531


What do you mean by rollback?

990


What is catalog database in db2?

1162