Which type of index is designed to improve query performance for columns with low cardinality?
- B-Tree Index
- Bitmap Index
- Clustered Index
- Hash Index
A Bitmap Index is specifically designed for columns with low cardinality, where there are only a few distinct values. It works by creating a bitmap for each distinct value in the column, indicating which rows contain that value. This allows for efficient retrieval of rows matching specific values, making it suitable for columns with low cardinality.
Loading...
Related Quiz
- In ETL processes, what does the "T" represent?
- In ETL testing, what is the primary goal of data validation?
- When should you use a LEFT JOIN in SQL?
- What challenges are typically associated with handling large volumes of data in ETL testing?
- Scenario: You are tasked with scalability testing for a cloud-based storage service. During the test, you observe that adding more virtual machines to the cluster does not significantly improve performance. What scalability issue might you be facing?