Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is database alias db2?
Is db2 a database?
List out the three types of page locks that can be held.
What is meant by union and union all?
What is release/acquire in bind?
What is the physical storage length of timestamp data type?
What are the bind parameters ibm db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Why do we bind in db2?
What is the maximum size of a char data type in db2?
What is db2? Explain.
What is with ur in db2?
what are bind concepts in db2 cobol?
Which isolation level provides highest data integrity?
Can you use max on a char column?
