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

How to get the ddl of a table in db2?

0 Answers  

On the create tablespace, what does the CLOSE parameter do?

1 Answers  

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

What is concurrency in db2?

1 Answers  

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

What os does db2 run on?

0 Answers  

what is rebinding ?

1 Answers   IBM,

why we create view.

5 Answers  

What is meant by isolation level?

3 Answers  

What can the SET option of the Repair Utility accomplish?

1 Answers  

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories