Know what you code
•What is the entity that each result row
(or each pre-aggregated result row) should represent?
What table or view maps to that entity?
•Is the table or the view mapping to the
results the (only!) root detail table, the only
table not joined to the other tables with its primary key? (Are all
joins from the single root node downward-pointing?)