Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.com!newscon06.news.prodigy.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!g49g2000cwa.googlegroups.com!not-for-mail
From: ns666ns@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: Re: slow query with IN list
Date: 12 Dec 2005 08:00:48 -0800
Organization: http://groups.google.com
Lines: 10
Message-ID: <1134403248.680623.201270@g49g2000cwa.googlegroups.com>
References: <1133993859.290794.148940@g47g2000cwa.googlegroups.com>
   <30pep1t16p9tfent23f61ag06pom4g2qj0@4ax.com>
NNTP-Posting-Host: 170.148.92.18
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1134403253 23241 127.0.0.1 (12 Dec 2005 16:00:53 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 12 Dec 2005 16:00:53 +0000 (UTC)
In-Reply-To: <30pep1t16p9tfent23f61ag06pom4g2qj0@4ax.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g49g2000cwa.googlegroups.com; posting-host=170.148.92.18;
   posting-account=u5NnOQ0AAAApU88r3tCWqyFzFZQIVafE
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:257556

I do not have enough privileges to do explain plan since the underlying
tables are controlled by another dept.

I can't put the 700 id's in table since they are dynamically created
and changes from query to query.
is there a way to "fake" this 700 rows dynamically so I can do
intersect?

thanks