Forum OpenACS Q&A: Re: IN clause limitation

Collapse
2: Re: IN clause limitation (response to 1)
Posted by Sebastiano Pilla on
Look up http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:210612357425

For example, quoting from the above page: "if you have such a seriously big inlist -- i would suggest you do not use this technique but consider loading the stuff into a global temporary table using bulk inserts and then query "where in (select * from gtt)""