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

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 30 Dec 2014 10:11:02 -0800
Message-ID: <CAORjz=M4AtmDUF=7vjGDepwo8GAKyYPJ4e1r9iCwRRxkHt1gWg_at_mail.gmail.com>

On Thu, Dec 18, 2014 at 9:59 AM, Jeff C <backseatdba_at_gmail.com> wrote:

> where emp_id in (select column_value from table(cast(t_numbers as
> num_tab)))

Have you tested this using a GTT rather than a huge where clause?

It would be much simpler, and more stable.

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 Tue Dec 30 2014 - 19:11:02 CET