Re: slow query with IN list

ns666ns_at_yahoo.com wrote:
> 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

No.

If there is a business need then you will be given the privileges you need or someone else will create the table. If they don't do it then the problem really isn't important.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)