Re: Performance: Nested Subqueries

Posted in 1996

Terry Boyland — 2 Jun 1996 13:49:36 GMT — source: Informix-list mailing list archive (1991-1998)

In article <4ogbeq$61b@news6.erols.com>, Diana Li <chanli@erols.com> says: > >We have applications with SQL SELECT statements having more than 10 >subqueries and over half of them are correlated subqueries. The code >runs very slow for hours to complete. The database tables are in >third normal form. > >What can I do about those type of SELECT statements in order to improve >performance ? > >Would use of temp. table with index created and join help ? But the >statement is about a page long. > >Thanks for any help ! Diana It is more than likely that temp tables will help There are some real coding guru's who read this group ( I exclude myself from this ) who I am sure will be able to re-write these for you just for fun. If they are only a page long why not post them Billy Wheeler and Jonathan Leffler would love the challenge I am sure ( No flames please guys !! ) Regards Terry Boyland