Where is the output of EXPLAIN stored?
Answers were Sorted based on User's Feedback
How to compare data between two tables in db2?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Where is the output of EXPLAIN stored?
What is copy pending and check pending in db2?
When do you use the IMAGECOPY?
Which component is responsible for processing sql statements and selecting access paths?
What are the uses of db2 optimizer?
What kind of database is db2?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What is a base table?
What is cobol db2?
What is the difference between Primary key and unique index?