Bitmap Index vs. B-tree Index: Which and When?
In this article I'll provide some examples, along with optimizer decisions, that are common for both types of indexes on a low-cardinality column as well as a high-cardinality one. These examples will help DBAs understand that the usage of bitmap indexes is not in fact cardinality dependent but rather application dependent.
Solving performance issues using Oracle Function-Based Indexes
Function-Based Index is one of the many new features
introduced in Oracle 8i. This functionality allows the database administrator to create indexes on functions or on even expressions. This article presents a practicla scenario where this new feature can help us.
