Interested to Buy Any Domain ? << Click Here >> for more details...
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
- 2 Answers
- 11172 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / andank
When MATCHCOLS is 0, the access method is called a Non-
Matching Index Scan.
In the Non-Matching Index Scan, all the index keys and
their RIDs are read. Basically DB2 reads the full index
for that query.
| Is This Answer Correct ? | 3 Yes | 0 No |
Which transaction use a command thread ?
What is null in db2?
Which isolation level provides highest data integrity?
What are the two types of logging in the db2 database? Explain them.
Define data page.
What is a buffer pool?
What are foreign keys?
What is the self-referencing constraint?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
How do you define a correlated name?
What db2 400?
Why cursor is used in db2?
COBOL 
