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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

Where is the output of EXPLAIN stored?

Question Posted / guest

Answers were Sorted based on User's Feedback



Where is the output of EXPLAIN stored?..

Answer / s

The Explains writes the output to the PLAN TABLE

Is This Answer Correct ?    5 Yes 0 No

Where is the output of EXPLAIN stored?..

Answer / mainframe.rahulz

EXPLAIN stores output in PLAN_TABLE

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is query_cache_limit?

0 Answers  

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  

How can deadlocks be resolved?

0 Answers  

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

0 Answers  

What is RUNSTATS?

3 Answers  

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  

How to find schema of a table in db2?

0 Answers  

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

how can i pull up a query which was previously stored in qmf

3 Answers  

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

For more DB2 Interview Questions Click Here
Categories