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

What is difference between rollback and commit?

1091


How would the varchar column remarks defined?

1035


What does a deadlock mean in DB2?

1094


What is the role of the data page in the db2 database?

972


What are db2 objects?

1000


What action db2 takes when a program aborts in the middle of a transaction?

1088


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?

8132


Define sqlca.

1054


What is buffer pool and list some of them?

980


What is the use of with ur in db2?

996


What is a Foreign Key?

1036


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

1065


Why cursor is used in db2?

984


Is db2 a mainframe?

968


What is the difference between spufi and qmf?

1053