Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am working on a dashboard and I am almost done with the data model, but due to requirements, all the tables are in island position with no linkage or join. As the data is tremendously huge so i want to avoid joins. would this approach effect th eperformance of my application?
Yes, tables as islands mean every calculation is based on a cartesian product of the tables involved. Very expensive.
Ok!! so if its not possible to link island tables, then what could be done? Creating a master calendar and linking it with evry table.. would that work?
No idea. I don't know your data or what result you're trying to achieve. See this discussion for some perfomance tips and this discussion about master calendars.
Thanks for you reply Wassenaar. What I want to know if there is a situation wherein you cannot link tables,then what alternatives do we have?