We've used alternate indexes to do trigger type processing since 1990.
In our case, we do it to handle two situations:
1. Track the records that have changed to handle secondary key updates
for files where the secondary data isn't really in the file. We have
a master person file for our police
Apologies to those of you in u2-community who are seeing this again.
The City of Salinas, in Salinas, CA (Central Coast of California) is
hiring a Senior Programmer Analyst. The following link contains information
on how to apply:
http://www.ci.salinas.ca.us/Admin/HRjobs/SrProg.html