시다바리
[Oracle] 비트맵 조인 인덱스(Bitmap join index)
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..
Database/Oracle
2008. 9. 24. 19:22