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

how to resolve -811

2 Answers   IBM,

---

What does runstats do in db2?

0 Answers  

---

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---

What is the use of reorg in db2?

0 Answers  

---

Mention some fields that are a part of sqlca.

0 Answers  

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

Can any one tell me about Restart logic in DB2.

2 Answers  

---

What is a correlated sub query?

2 Answers  

---

What is correlation names?

1 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

On the create tablespace, what does the CLOSE parameter do?

1 Answers  

---