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's The Percentage Free Space ?
What os does db2 run on?
What is the difference between cursor and select statement?
Outputs of explain are with matchcols = 0. What does this signify?
Name the various locking levels available?
What are foreign keys in db2?
Explain what are the various isolation levels possible?
What are the contents of a dclmgen?
What is performance tuning db2?
How to run db2 command in windows?
What is universal database?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How to resolve deadlock issue
Define db2.
What is database reorganization?
