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
Outputs of explain are with matchcols = 0. What does this signify?
How to find primary key of a table in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is declare cursor?
How to check last update on table in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is db2 look?
How does coalesce work?
What is db2 stogroup?
What does db2 mean?
Which command is used to remove all rows from a table?
How do we specify index to include or not during bind process.
What is the purpose of rollback and commit?
What is a bind in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?