Re: Large # Items in IN () Very Slow

From: Jonathan D. Trumbull <Jonathan.Trumbull_at_abbott.com>
Date: 30 Oct 2002 04:51:53 -0800
Message-ID: <266c2da3.0210300451.c3048b4@posting.google.com>

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<GpHv9.167287$%d2.58433_at_sccrnsc01>...

> Are you using bind variables?

The SQL is from a third party tool and they don't use bind variables. This isn't usually a problem since it's a datamart and there are "very few" queries compared to the amount of data transfered per query. Also, switching the TIMED_STATISTICS on like Stan suggested shows that only 170ms is being consumed parsing the query. Maybe I misunderstand these numbers...

Thanks!

--Jonathan Received on Wed Oct 30 2002 - 06:51:53 CST