I am posting this for the Author Phil Leach with his permission. It works
great. The enclosed files will build an application that takes summary
information from a main table and propagates a second table. This is useful
if you find yourself doing queries like SELECT DISTINCT maintable.fieldname
from maintable Now you can do SELECT summarytable.fieldname from
summarytable which will be substantially faster. It was written to answer a
specific problem on my server and as such may have some machine dependent
coe left in that I have missed. Feel free to modify to suit your needs. I
have successfully run it on a Solaris 2.4 machine but see no reason why it
wouldn't work every where. Hope this helps. David Perry p.s. Any errors you
find are likely mine as a result of me taking out the machine dependency and
shouldn't be blamed on Phil, a really bright guy.
