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 ibm db2 client?
How do I delete a table in database?
How can deadlocks be resolved?
Can one database have multiple instances?
How to find the number of rows in a db2 table?
What is the maximum number of columns in a db2 table?
How can you count the number of rows from a table tab?
Is db2 free?
Define predicate?
What do you mean by storage group (stogroup)?
How to fetch the last row from the table in SQL (db2)?
What is ibm db2 connect?
How would you find out the total number of rows in a db2 table?
How to view db2 table structure?
What is the use of runstats in db2?
