what are stage one indexable predicates?
Answer / yuvaevergreen
Indexable predicates are the one which match with index
entries. It depends on the indexes that are available and
the access path chosen at bind time.
For example,if the employee table has an index on the
column LASTNAME,
the following predicate can be a matching predicate:
SELECT * FROM emp WHERE LASTNAME = 'SMITH';
Stage 1 predicates are the predicates which are processed
by Data
manager component of DB2 as soon as it recieves data from
the buffer manager.
Some examples are:
COL BETWEEN value1 AND value2
COL IN (list)
COL LIKE host variable
more examples:
http://publib.boulder.ibm.com/cgi-bin/bookmgr/
BOOKS/dsnapj12/6.3.3.2?
DT=20050328013405#TBLISARG
Is This Answer Correct ? | 0 Yes | 0 No |
How to resolve -805 error in DB2?
What is the difference between cursor stability and repeatable read isolation levels?
what is the responsibility of the construction superintendent
What are the full forms of spufi and dclgen and why are they used?
What happens to a cursor after a commit?
Explain what are the various isolation levels possible?
WHAT IS MEANT BY COMMIT COMMAND?
The only place of VSAM KSDS in DB2 is?
Mention data types used in db2 ?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How is deadlock resolved?
What is bind package and plan in db2?