Avoid Costly Joins with FBIs

Authors

Abstract

This article describes how to use Function-Based Indexes to avoid costly joins. Data warehouses are particularly suited to the usage of this technique, since joins tend to be heavy operations and dimensions are scarcely updated. This technique is only applicable in Oracle8i.

Keywords

Query optimization, function based indexes, data warehousing, joins, Oracle, Oracle8i

Subject

Technical Advice - Data Warehousing

Journal

Oracle Professional Newsletter, Vol. 7, #9, pp. 1-6, Farion Grove (Editor), September 2000

PDF File