IFX_FOLDVIEW

Posted in 2011

Tom Lehr — Thu, 30 Jun 2011 07:09:49 -0700 (PDT) — source: Usenet: comp.databases.informix

anyone experience any negative effects turning on this config parameter? thanks tom You can significantly improve the performance of a query that involves a view by enabling view folding with the IFX_FOLDVIEW configuration parameter. When the IFX_FOLDVIEW configuration parameter is enabled, views are folded into a parent query. Because the views are folded into the parent query, the query results are not placed in a temporary table.