B-tree index is preferred where the cardinality of the dimension is more this will be used in the line item dimension. You can find it when creating line item dimensions. By default rest are BitMap indexes.
You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
Add a comment