Important Observations
- With a relatively small number of total records read, you will not notice any performance improvement for this design.
- For a much larger set of tables, this design would be essential for performance reasons.
Tips & Techniques
- If the high-level table, departments in this case, has a large number of records, you would limit the initial data loaded by including a search or filter.
What You Should Know
- How to implement an unlevelled tree view, loading data on demand.