Interested to Buy Any Domain ? << Click Here >> for more details...
what are stage one indexable predicates?
- 1 Answers
- 6213 Views
- I also Faced
- E-Mail Answers
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 |
How is the SUBSTR keyword used in sql?
What is meant by isolation level?
What happens in bind step in a db2 program?
what is the role of the cursor in db2?
What is netezza database?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
What is ALTER ?
What is bind and rebind in db2?
How to solve S0C7 abend with out using DISPlay in 10 mins?
What are the full forms of spufi and dclgen and why are they used?
What is referential integrity?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
COBOL 
