Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what are stage one indexable predicates?



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

Post New Answer

More DB2 Interview Questions

When Can you be sure that a query will return only one row?

4 Answers   IBM,


What are the three types of page locks that can be held?

1 Answers  


How does db2 sample database connect?

0 Answers  


What is coalesce in db2?

0 Answers  


Mention the definition of cobol in varchar field.

0 Answers  






what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,


What is db2 stogroup?

0 Answers  


can we drop column from a table

7 Answers   INDUS,


What is a view? Why use it?

2 Answers  


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  


What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,


What is copy book?

1 Answers   Thomson Reuters,






Categories