Any experience with EVI indexes?

If I understand correctly, an EVI index can have a field with the total for each account and reading it should be faster than reading the total in a table, and, better yet, you don't need a trigger to maintain it.

Eric Lehti wrote:

I succeeded in attaching a second trigger program to a file yesterday.
Happy. I did not realize that system will allow more than one trigger
program.

I did not want to modify the existing (first) program trigger that
tracks sales order totals in real-time.

I created second trigger program with JD Edwards DBAM (data base audit
manager) to identify which process is changing info in one field.

How many trigger programs will system allow on a file? I will find out
someday.





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.