Forum Discussion
Efficiency - advice on structuring data
I am looking for some general advice. I have a moderate sized model (about 20 tables). Most tables link into the order table in a normal star schema but the order table then links down furth into...
Thank you for responding but this does not answer my question. I want to understand whether the calendar should link into the order table OR into the order line table for most efficient handling. I totally understand the calendar cannot link actively into two tables at once.
Anonymous , depends. What Date is most needed? I would have preferred the order header as most of the filter will coming on the order date. For any line-specific filter, I can use the line date itself.