What is meant by db2 predicate

jeelagahema · New User Joined: 12 Jun 2005 Posts: 12 Location: bangalore

what is meant by db2 predicate

sathish_rathinam · New User Joined: 22 Aug 2005 Posts: 59 Location: india

hi ,

predicate is an element of search condition which implies a comparision operation..

cheers,
sathish

Kavitha Palani · New User Joined: 16 Nov 2005 Posts: 8

A predicate is an element of a search condition that expresses or implies a comparison operation

senthilssg · New User Joined: 09 Dec 2005 Posts: 64 Location: USA

Hi,

there is a two predicates are available..
primary predicate and secondary predicate
primary predicate is done in data manager and secondary predicate is done in relational data system (RDS).
so we should write query such that most of the process should be taken at the data manager by primary predicate ..

eg; if u use IN and BETWEEN are evolved in datamanager . ie no of records selected from the system for execution is limited in the first step itself .

In secondary predicate , out of selected rows from the data manager filter process ie colums which are wanted are taken out and dispalyed..

eg: all the simple select are secondary predicate

Regards,
Senthil kumar.k
chennai