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..