Re; Informix View Performance (Was: RE: Using procedures to maintain derived data)

Terry Boyland <Terry@century.demon.co.uk> wrote: >Some interesting comments here on the use of views > >I too have had no end of problems trying to get better >performance out of them and we still have not been able to >acheive it. I'd sure like to see some comments from any Informix gurus as to the best way to make them useful. I would love to see derived fields supported by Informix, such as Interbase's method. There are probably several other DBMS's out there which support this, though I'm not familiar with them. Views just don't seem to work well enough without some heavy-duty hardware. Any comments? -- Mike Lemon mdl@interpath.com