Re: IN question

["Mat Caughron" <caughron(at)gmail(dot)com>]

So anyone know what circumstances caused the implementation of a 64 kilobyte
query size limit that was in Oracle 9i?

I suspect there's an opportunity here to benefit from prior lessons learned
the hard way (e.g. size limit too small or too big).


Mat Caughron


On Tue, Dec 9, 2008 at 2:43 PM, Meredith L. Patterson <
mlp(at)thesmartpolitenerd(dot)com> wrote:

> Eric Walstad wrote:
> > The results I found suggest the limit is based on available memory but
> > I didn't find anything definitive.
>
> That's probably the case, as there's no fixed upper bound on query length.
>
> --mlp
>