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

What is bind package and plan in db2?

0 Answers  

---

What is usage pointer in cobol?

3 Answers   IBM,

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers  

---

How do you select a row using indexes in db2?

0 Answers  

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

What are delete-connected tables?

1 Answers  

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

define clustering index.

0 Answers  

---

What is the difference between drop table and delete table?

0 Answers  

---

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  

---

What are foreign keys?

1 Answers  

---