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
What is db2 instance?
What is a db2 tablespace?
What is cobol db2?
What do you mean by storage group (stogroup)?
What is db2 command?
How would you find out the total number of rows in a db2 table?
What is the difference between bind and rebind in db2?
List down the data types in the db2 database.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the use of db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is precompiler in db2?
What is drop table?
Explain various types of locks in db2?
How to retrieve rows from a db2 table in embedded sql?