Automatic Indexing . Exams of Oracle . The Clustering Factor
Bitmap Join Indexes-Indexes
On 04/02/2022 by Robert CorvinoNormally, an index is created on a single table, using only columns from that table. A bitmap join index breaks that rule and allows you to index a given table using columns from some other table. In effect, this allows you to denormalize data in an index structure instead of in the tables themselves. Consider
