EXPLAIN has output with MATCHCOLS = 0. What does it mean?
Answer Posted / s
Non-matching index scan
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How to execute stored procedure in db2 command editor?
What is bind plan?
What is the difference between cursor stability and repeatable read isolation levels?
What is the use of db2 optimizer?
What are concurrency issues?
List out the buffer pools in db2
What is db2? Explain.
What is alias in db2?
What is coalesce in db2?
What is the purpose of using commit?
What does db2 blu stand for?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How to find the number of rows in db2 tables?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?