Know what you code - views
•Do rows from the view map cleanly,
one-to-one, to a single entity? (Are the view-defining
join trees clean?) Is that exactly the right entity
for purposes of your query?
•Are there elements in the view (joins, subqueries)
that are unnecessary or redundant to your
query?
•Will use of the view still be
correct when and if the view changes?