시다바리

Bitmap Join Indexes (BJI) is new functionality provided by Oracle9i. A Bitmap Join Index prestores the results of a join and thus can avoid a join operation altogether at runtime. Bitmap Join Indexes are especially useful in datawarehouse star schemas. When a column in a dimension table is used to restrict the data selected from a fact table (with Foreign Keys) and n dimension tables (with Prima..