This content has been marked as final. Show 2 replies
I'd like to simplify my data model, to improve performance. I've built a set of cross tables from the same base of data, to account for different kinds of information:
- Costs by year, and by month
- Volume by year, and by month
The original table was 800K rows, so you can imagine now there are millions of rows, just for the luxury of having crosstables. It's quite sluggish, and I'd like to find ways to streamline more. Pls opine!