. . . and because of the extra work in evaluating DISTINCT, it's worth thinking carefully which you actually NEED.

(I'm currently going through and correcting a bunch of views that have unnecessary DISTINCT's - used by over-cautious developers who weren't working on full size tables! Some nice performance improvements.)