>BTW, here is the problem, I was trying to create a test case:
>
>User has ability to type whatever number of zipcodes for selection criteria, as he/she pleases. My Criteria Form creates a serious of inlist, if the number is less than some max_number (property of class). I currently set it to be 72, so there would be 3 inlists e.g. inlist(zipcode, code1,code2,..,code24) or inlist(zipcode,code25,...,code48) or ...
>If the number is greater, I create a temp table and join to it, so this increases number of joins by 1. This seems to be executed too long, so I'm thinking, what could be reasons for this long execution and would I gain improving in perfomance, if I increase my max_number and would use more inlists, 5, in this particular case...
>
>However, I postponed these tests due to my manager told me, that we probably would implement Data Warehouse for One-time jobs too...

Just an FYI. You may be reaching a limit with the number of joins. But, just wanted to ask if you've created an index on ZIPS for the temporary table.

As you say, the issue may be passé.

Jay