#
# Oracle Performance Tuning Chapter 5 p. 79
#
# For the normalized database:
SELECT PART_NO, ORDER_NO, CLASS, CLASS_DESC
    FROM CLASS C,
    PART P,
    ORDER O
    WHERE O.PART_NO = P.PART_NO
    AND P.CLASS = C.CLASS;
#
# For the denormalized database:
SELECT PART_NO, ORDER_NO, CLASS, CLASS_DESC
    FROM CLASS C,
    ORDER O
    WHERE O.CLASS = C.CLASS;