Interested to Buy Any Domain ? << Click Here >> for more details...
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
- 2 Answers
- 11170 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 |
What keyword does an SQL SELECT statement use for a string search?
What is declare cursor?
What is rct?
Outputs of explain are with matchcols = 0. What does this signify?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is table space in db2?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
Do we need cursor for Count(*)?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
When do you specify the isolation level?
What are the various locking levels available?
What is the meaning of -805 SQL return code?
COBOL 
