what are stage one indexable predicates?
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 |
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Where is the output of EXPLAIN stored?
What is a db2 tablespace?
How is deadlock resolved?
What is the latest version of ibm db2?
i have a db2 variable how do u declare tht into working storage section ?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
How do you do the EXPLAIN of a dynamic SQL statement?
What is dynamic SQL?
what is sql abend code -801,-802?
What is a db2 cursor?
What is explain in db2?