Question

["Bhattaru, Ram (NIH/NCI)" <bh...@mail.nih.gov>]

Hi,

   I have two questions. 

   1.  Is there a way to tell OJB to use Sub-Queries instead of Joins?
   2.  Is there a way to provide the criteria values from a temporary table
in IN clause.  i.e. if I have hundreds of values that in IN clause, it takes
very long time to process the query.  At the same time, if these values are
present in a (temporary) table, then the using a join between this temp
table and the real table column takes less time than sending these hundreds
of values in IN clause.

   Can someone please answer these questions.

   Thank you

Ram Bhattaru
Center for Bioinformatics (NCICB) , National Cancer Institute 
Advanced Information Technology Center (AITC), SAIC 


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org