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

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 7 Jan 2015 08:33:34 -0800

On Tue, Dec 30, 2014 at 4:21 PM, Jeff C <backseatdba@xxxxxxxxx> 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

Other related posts: