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 sqlca’s maximum length?

1112


What is database reorganization?

1066


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1129


define clustering index.

986


Before you give the explain statement, what are the prerogatives?

982


What is schema in db2?

974


what is a corelated subquerry?

1075


What is the syntax for creating a table in the db2 database?

1066


How do I import data from excel to db2?

1024


What is the use of commit in db2?

1012


How to test SQL -911 error while developing COB-DB2 program

7461


What is the use of value function?

1087


On which levels locks can be applied?

1070


How is a typical db2 batch pgm executed?

1122


How can you classify the locks in db2?

1041