"Philip Sherman" <psherman@ameritech.net> wrote in message
news:guZmc.397$gV7.360@newssvr32.news.prodigy.com. ..
> SELECT columns
> FROM t1
> JOIN t2
> .
> .
> .
> WHERE predicates
>
> The from/join contains 5 tables, one of which is created from a select
> statement.
>
> The columns area contains 35 selects, some of them containing a join,
> referencing a total of 40 tables.
>
> UDB 8.1 Windows and Linux both hard crashed (complete instance shutdown)
> trying to process this statement. (Yes, I have dumps from Linux and may
> be able to get to the Windows dumps next week.)
>
> Please don't ask me where this came from - I didn't write it and just
> have to make it work within the next two days.
>
Check the SQL limits in the SQL Reference for the most tables or joins in
one statement. If you are not on fixpak 5, I would install it now.

I don't care where it came from, but the person who did it should be tarred
and feathered.