Desktop productivity for business analysts and programmers

BTree/Bitmap index equivalent in SAS datasets

Reply
N/A
Posts: 0

BTree/Bitmap index equivalent in SAS datasets

Quick question - Like how in ORACLE, we have different types of indexes like Bitmap and Btree, is there anything like this in SAS datasets.
What we are trying to acheive is , for low cardinality columns , have a bitmap index and for high cardinality ones use Btree.Any thoughts?
Super Contributor
Super Contributor
Posts: 3,174

Re: BTree/Bitmap index equivalent in SAS datasets

Using the Google advanced search argument listed below, I found several topic-related technical papers relevant to the subject of your post at the SAS support http://support.sas.com/ website which may be useful:

cardinality bitmap btree site:sas.com


Scott Barry
SBBWorks, Inc.
Esteemed Advisor
Posts: 5,198

Re: BTree/Bitmap index equivalent in SAS datasets

For Base SAS tables, there is just ordinary B-Tree indexes available. So there is not much to do there I'm afraid.

But for SPDE and SPD Server table, a so called Hybrid index is used, which will pick the best from both worlds, B-tree and bitmap. The best part is that you don't have to chose, you will get the best performance without having to decide/know the cardinality of data on beforehand. See on-line doc for mode details.

/Linus Message was edited by: Linus H
Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 383 views
  • 0 likes
  • 3 in conversation