Re: many Union all vs. inserting results to temp table

deann15_at_yahoo.com wrote:

> Depending on what a user select, the query could have a few thousand
> unions.\

I'd stop right there. Fix the design. Or perhaps, more correctly, fix the lack of design. This is a nightmare by any reasonable definition.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)