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 the reason behind not using select * in embedded sql programs?
How to view db2 table structure?
is it compulsory commitment control in journal?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is db2 connect?
Is db2 free?
What does reorg do in db2?
What is null value in db2?
i want to maintain uniqueness on pdf without make lf??????????
What are host variables in db2?
What is netezza database?
What is runstats db2?
What is load replace in db2?
How is a typical db2 batch pgm executed?
How is the value function used?
