|
In my SQL ignorance I made LF = VIEW... And I WAS thinking VIEWs as a more efficient way to access data instead of DDS. I can now choose between: UDTF, LF or Trigger. Creating 200 LF over a single phisical is something I never done and I don't know if there is a performance issue. UDTF, nice approach since I have a single object for multiple data libraries. Trigger, 200 phisical files to write/update/delete I think trigger is the light one. Thanks Marco --- Vernon Hamberg <vhamberg@xxxxxxxxxxx> wrote: > 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 > ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs
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.