Reasons Not to Denormalize Using Derived Data The following items deal with the issues of derived data without denormalizing user base data tables: Aggregate join index (see “Aggregate Join Indexes” on page 503) Global temporary table with derived column definitions View with derived column definitions