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.

I have not noticed anything negative. But it has done wonders with
speeding up our views here.

Nick