IFX_FOLDVIEW

This is what is in the release notes for 9.40.FC8: 1.5.2.1 Enabling View Folding to Improve Query Performance For certain situations where a view is involved in a query, view folding can significantly improve the performance of the query. In these cases, views are folded into a parent query instead of the query results being put into a temporary table. Use the IFX_FOLDVIEW configuration parameter to enable or disable view folding: 0 (default) disables view folding 1 enables view folding The following types of queries can take advantage of view folding: * Views that contain a UNION ALL clause and the parent query has a regular join, Informix join, ANSI join, or an ORDER BY clause * Views with multiple table joins where the main query contains Informix or ANSI type outer joins A temporary table is created and view folding is not performed for the following types of queries that perform a UNION ALL operation involving a view: * The view has one of the following clauses: AGGREGATE, GROUP BY, ORDER BY, UNION, DISTINCT, or OUTER JOIN (either Informix or ANSI type). * The parent query has a UNION or UNION ALL clause. On 24 May 2006 07:56:36 -0700, scottishpoet <dryburghj@yahoo.com> wrote: > > so new its not available yet, thats why you won't find much about it > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >