I agree with the CIO.
Sooner or later, the summary table will bite you.
As Hugo says, a view solves the problem.
If the CIO complains about the view, well..



>I'll probably get fired so saying this, but my CIO has laid down the law saying we can no longer use a summary table to get data about our members and, instead, we need to go to the "Master Data" tables.
>
>We have almost 200,000 members and we have a lot of date sensitive layered data about the member in many different tables. Typically, we want to get the most recent layer data item like their current address - not their address five years ago.
>
>We have a VFP table and a VFP process that summarizes some 150 fields worth of data into a summary table for the members. The process takes over an hour to run.
>
>So, instead of one stop shopping using the summary table the CIO says we have to go to each history data table and pull the max address or whatever.
>
>I don't see the advantage of this approach other than it will slow things down and make the code more complex.
>
>Opinions?