Return-Path: 
 <ojb-dev-return-7577-apmail-db-ojb-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ojb-dev-archive@www.apache.org
Received: (qmail 33339 invoked from network); 24 Feb 2004 20:13:33 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 24 Feb 2004 20:13:33 -0000
Received: (qmail 82740 invoked by uid 500); 24 Feb 2004 20:13:22 -0000
Delivered-To: apmail-db-ojb-dev-archive@db.apache.org
Received: (qmail 82711 invoked by uid 500); 24 Feb 2004 20:13:22 -0000
Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:ojb-dev-unsubscribe@db.apache.org>
List-Subscribe: <mailto:ojb-dev-subscribe@db.apache.org>
List-Help: <mailto:ojb-dev-help@db.apache.org>
List-Post: <mailto:ojb-dev@db.apache.org>
List-Id: "OJB Developers List" <ojb-dev.db.apache.org>
Reply-To: "OJB Developers List" <ojb-dev@db.apache.org>
Delivered-To: mailing list ojb-dev@db.apache.org
Received: (qmail 82697 invoked from network); 24 Feb 2004 20:13:22 -0000
Received: from unknown (HELO ims.hub.nih.gov) (128.231.90.111)
  by daedalus.apache.org with SMTP; 24 Feb 2004 20:13:22 -0000
Received: by ims.hub.nih.gov with Internet Mail Service (5.5.2657.72)
	id <FNKH261A>; Tue, 24 Feb 2004 15:13:26 -0500
Message-ID: <8A7350C73265A54587D23E30D15D9380017B9361@nihexchange13.nih.gov>
From: "Bhattaru, Ram (NIH/NCI)" <bhattarr@mail.nih.gov>
To: "'ojb-dev@db.apache.org'" <ojb-dev@db.apache.org>
Subject: Question
Date: Tue, 24 Feb 2004 15:13:23 -0500
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2657.72)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

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