 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
08-27-2008, 11:30 AM
|
|||
|
|||
|
Indexing Low Cardinality columns in a data warehouse scenario
Folks,
It seems that SQL Server 2005 does not yet support explicitly defined Bitmap indexes? Mention is made in the documentation that SSAS utilizes them implicitly. However I have a requirement to facilitate speedy response via SQL access rather than via a cube and OLAP. In a data warehouse scenario with a customer dimension projected to be about 5 million rows what is the considered opinion of the panel as to the best way to support efficent and speedy searches on a low cardinality column such as gender, age range, geographical region and so forth? TIA, Tim 
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
