Where is the output of EXPLAIN stored?

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 scrollable cursor in db2?

0 Answers  


Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  


assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,


AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,


how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,






can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,


which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,


How to check sequence on a table in db2?

0 Answers  


List some fields from sqlca?

0 Answers  


explain about index with examples

2 Answers   Syntel,


What is runstats utility in db2?

0 Answers  


Give some example of statistics collected during RUNSTATS?

1 Answers  


Categories