|
Note that if you're at v5r3, you can materialize the view so that the run time considerations don't apply. The view is then kept upto date just like a MAINT(*IMMED) logical. HTH, Charles Wilt -- iSeries Systems Administrator / Developer Mitsubishi Electric Automotive America ph: 513-573-4343 fax: 513-398-1121 > -----Original Message----- > From: midrange-l-bounces@xxxxxxxxxxxx > [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Vernon Hamberg > Sent: Tuesday, August 02, 2005 8:47 AM > To: Midrange Systems Technical Discussion > Subject: RE: Create View > > > A further consideration - you mentioned the performance issue > in reply to > the post about UDTFs - but views are also run at the time you > use them - > the SQL SELECT that is used to define the view is run dynamically, so > performance is an issue there, as well. Whereas the LF access path is > maintained and can even include an index. > > Maybe? > > Vern >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.