Re: where clause filter from an array or use temp table?

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 7 Jan 2015 08:33:34 -0800
Message-ID: <CAORjz=MTuXJ99+6vwtZSr79SLDOA3BF5wFLnbYF3D6btBNw25Q_at_mail.gmail.com>

On Tue, Dec 30, 2014 at 4:21 PM, Jeff C <backseatdba_at_gmail.com> wrote:

> Yes the GTT is must faster than using my collection.

Ah, triple threat!
(simpler, more stable, *and* faster)

Glad to hear that worked well.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/ Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 07 2015 - 17:33:34 CET