Partitioning, Bitmap Indexing (when to use), how will the bitmap indexing will effect the performance?
Bitmap indexing is an indexing technique to tune the performance of SQL queries. The default type is B-Tree indexers which is of high cardinality (normalized data). You can use bitmap indexers for de-normalized data or low cardinalities. The condition is the amount of DISTINCT rows should be less than 4% of the total rows. If it satisfies the given condition then bitmap indexers will optimize the performance for this kind of tables.
