What do you need to do before you do EXPLAIN?
- 1 Answers
- 4836 Views
- I also Faced
- E-Mail Answers
What do you need to do before you do EXPLAIN?..
Answer / s
Create the Plan_table to holds the results of the explain.
| Is This Answer Correct ? | 5 Yes | 0 No |
More DB2 Interview Questions
How does coalesce work?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
How is a typical db2 batch pgm executed?
What are types of indexes?
What is meant by AUTO COMMIT?
What are the abend codes occour in ur latest PROJECT in DB2
What is a data page?
What is clone table?
Plan has the optimized access path in it. But is that optimized access path is attained or known
select distinct(empid),distinct(dept),name from EMP will the above query work?
What is db2 command?
What is a plan and package in db2?
COBOL 
