Interested to Buy Any Domain ? << Click Here >> for more details...
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
- 2 Answers
- 11017 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 is the physical storage length of timestamp data type?
What is the usage of open cursor command?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
How do you filter out the rows retrieved from a Db2 table ?
what is consistency token
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is drop table?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is difference between rollback and commit?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
COBOL 
