Re: Materialized views

Posted in 2006

Carlton Doe — Thu, 04 May 2006 21:33:52 — source: IIUG Forums & Mailing Lists

Well the manuals do say that the view will be materialized through the use of temp tables if the SQL of the view definition is too complex. This occurs on a per operation basis rather than persistant so "performance enhancements are possible using regular views." he he he!!! On Thu, 4 May 2006, ART KAGEL, .... wrote: > > I know. It does not. Just normal views. > > Art S. Kagel > > ----- Original Message ----- > From: Peter_logan.... <ids@iiug.org> > At: 5/04 11:38:56 > > I know the answer to this is most likely in a manual somewhere ... > hopefully this is faster though ... > > Does anyone know if IDS 10 supports materialized views ... or virtual > tables that can be shared between sessions ... > > Peter > Carlton ______________________________________________________________________ Carlton Doe Flower Mound, TX dbaresrc at xmission dot com http://www.xmission.com/~dbaresrc http://www.iiug.org