>>Kevin,
>>
>>> the SQL consists of 1000's of UNION selects
>>
>>You need a serious redesign of that query!
>
>Unfortunately it's a generated query, typically when we perform searches against the database we just return the primary key's to save time, then if necessary the records are fetched in whole.
>
It still doesn't explain why you need 1000's UNIONs. :)