Oracle bitmap indexes and PostgreSQL bitmap - Oracle to Aurora PostgreSQL Migration Playbook
Oracle usagePostgreSQL usage
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Oracle bitmap indexes and PostgreSQL bitmap

With Amazon DMS, you can efficiently migrate databases utilizing Oracle bitmap indexes for optimized query performance. Oracle bitmap indexes are data structures that improve the efficiency of data filtering operations on tables with low cardinality columns.

Feature compatibility Amazon SCT / Amazon DMS automation level Amazon SCT action code index Key differences

Two star feature compatibility

No automation

Indexes

PostgreSQL doesn’t support BITMAP index. You can use BRIN index in some cases.

Oracle usage

Bitmap indexes are task-specific indexes best suited for providing fast data retrieval for OLAP workloads and are generally very fast for read-mostly scenarios. However, bitmap indexes don’t perform well in heavy DML or OLTP workloads.

Unlike B-tree indexes where an index entry points to a specific table row, a bitmap index stores a bitmap for each index key.

Bitmap indexes are ideal for low-cardinality data filtering where the number of distinct values in a column is relatively small.

Examples

Create an Oracle bitmap index.

CREATE BITMAP INDEX IDX_BITMAP_EMP_GEN ON EMPLOYEES(GENDER);

For more information, see CREATE INDEX in the Oracle documentation.

PostgreSQL usage

Amazon Aurora PostgreSQL doesn’t currently provide a directly comparable alternative for Oracle bitmap indexes.