what are stage one indexable predicates?
- 1 Answers
- 5499 Views
- I also Faced
- E-Mail Answers
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 |
Which one allows duplicate values Union or Union All ?
What is the latest version of ibm db2?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
How to update more then one record using update?
Explain about rct in db2?
what is the process of precompiler?
How to get the ddl of a table in db2?
What is meant by the attachment facility?
How many types of page locks can be held in db2?
What is database reorganization?
What is role in db2?
What is a DB2 bind?
COBOL 
