Interested to Buy Any Domain ? << Click Here >> for more details...
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
- 2 Answers
- 10969 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 |
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What is cascading rollback?
What is the size of a data page?
How to fetch the last row from the table in SQL (db2)?
What does DSNDB07 database do?
What does runstats do in db2?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
define clustering index.
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
What is a db2 schema?
COBOL 
