|
Rick, I know this isn't what you want to hear either, but here's a suggestion: Create a real physical w/the data you want in the "view" as real fields along with the primary key. You can then create indexes over this new file. You can add triggers to the original file to keep this redundant file in sync with the real one. And for safe measure a simple report that compares the values stored on the file to those that should be there and reports differences (should always be an empty report). I've used this setup a couple of times on the iSeries and on SQLServer with great success. BTW, SQLServer 2000 introduced "indexed views" which are system-maintained versions of this very setup. Works great. -Walden ------------ Walden H Leverich III President & CEO Tech Software (516) 627-3800 x11 WaldenL@xxxxxxxxxxxxxxx http://www.TechSoftInc.com Quiquid latine dictum sit altum viditur. (Whatever is said in Latin seems profound.)
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.
midrange.com
