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 multi row fetch in db2?

1052


How to check table size in db2 sap?

1040


What is sqlca’s maximum length?

1192


What is universal database?

1072


Explain the contention situations caused by locks?

1070


What is isolation level in db2?

1006


What is difference between alias and synonym in db2?

1143


What is query_cache_limit?

971


What is an instance database?

1054


What is dbrm? What it contains?

1163


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2217


What is the use of commit in db2?

1083


What is copy pending status in db2?

1127


How to fetch the last row from the table in SQL (db2)?

1657


What type of database is db2?

971