Re: slow query with IN list

From: <xhoster_at_gmail.com>
Date: 12 Dec 2005 18:30:59 GMT
Message-ID: <20051212133059.012$bU@newsreader.com>

ns666ns_at_yahoo.com wrote:
> I do not have enough privileges to do explain plan since the underlying
> tables are controlled by another dept.

We can't fight your political battles for you.

> I can't put the 700 id's in table since they are dynamically created
> and changes from query to query.

Isn't that the raison d’être of temporary tables?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB

Received on Mon Dec 12 2005 - 12:30:59 CST