"Materialized" Views

Hi All, My system: Solaris 10, IDS 10.FC6X7 I got a request to optimize the time it takes to select from a view in our system. I first thought of materialized views. However there seems to be different meanings to that terminology. Not knowing Oracle very well at all it seems that Oracle has the "materialized" view which stores the actual results in a "table" while Informix calls the temp table it might build during a select from a view that has a union clause a "materialized" view. So, do we in Informix have a way to optimize a view? TIA, Zev Berezin

Hi Zev Informix doesn't support Materialized view. If your query didn't cause server to creates a temporary table for the view, you will not see the query slow. To determine if you have a query that must build a temporary table to process the view, execute the SET EXPLAIN statement. If you see Temp Table For View in the SET EXPLAIN output file, your query requires a temporary table to process the view. Regards, --- On Thu, 4/23/09, Zev Berezin <zevb@bhphoto.com> wrote: > From: Zev Berezin <zevb@bhphoto.com> > Subject: "Materialized" Views [15599] > To: ids@iiug.org > Date: Thursday, April 23, 2009, 10:53 AM > Hi All, > > My system: Solaris 10, IDS 10.FC6X7 > > I got a request to optimize the time it takes to select > from a view in our > system. > > I first thought of materialized views. > However there seems to be different meanings to that > terminology. > Not knowing Oracle very well at all it seems that Oracle > has the > "materialized" view which stores the actual results in a > "table" while > Informix calls the temp table it might build during a > select from a view that > has a union clause a "materialized" view. So, do we in > Informix have a way to > optimize a view? > > TIA, > Zev Berezin > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the > discussion forum. > >