Archives of the TeradataForum
Message Posted: Fri, 23 Jan 2004 @ 15:18:53 GMT
| Subj: || || Re: Misunderstanding of join index |
| From: || || Schroter, Andrew |
JOIN indexes enable you to get query performance benefits closer to that of denormalizing data without bearing the costs of update anomalies
and performing a denormalization of the data model. In addition, as JOIN INDEXES are updated as the underlying data is updated, the immediate
availability of queries based on new "denormalized" views of data is dramatically improved compared to traditional denormalized schemes.