Multiple choice technology performance

Different types of Indexes available

  1. B*Tree

  2. Bitmap

  3. Bmap

  4. Function Based Indexes

Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

B*Tree indexes are the most common index type for equality and range queries. Bitmap indexes are efficient for low-cardinality columns. Function-based indexes store the results of function calls to improve performance of queries using those functions. 'Bmap' is not a standard index type.