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
What is db2 optimizer?
Explain about mirror activator disk mirroring?
what is a corelated subquerry?
How to check last update on table in db2?
What is a db2 table?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What are types of indexes?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the default page size of buffer pools?
What is the role of data manager in the db2 database?
What is concurrency?
What is drop table?
What is temporal table in db2?
What is cobol db2?
What is a plan and package in db2?