Microsoft KB Archive/304155

= INF: Advantages of Using Numeric Dimension Keys =

Article ID: 304155

Article Last Modified on 2/20/2007

-

APPLIES TO


 * Microsoft SQL Server OLAP Services
 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q304155



SUMMARY
The Key Data Type property of a dimension indicates the data type of the columns that store member keys in aggregations. Member keys are copied from the column specified in the Member Key Column property. This article explains some of the advantages of using numeric keys as opposed to character keys.



MORE INFORMATION
The type of data indicated by the Key Data Type property affects processing time, the size of the dimension structure and memory usage. If the Key Data Type property is set to a character data type, processing requires string comparisons, which is more time consuming. Conversely, if the Key Data Type property is set to a numeric data type, processing involves simpler number comparisons resulting in faster processing.

Numeric values have the same length, which simplifies and reduces storage requirements. String values can be of variable lengths and are stored differently than numeric values, which results in an additional level of indirection and greater storage requirements. Memory requirements for string values are also higher than for numeric values, which results in larger dimensions and greater memory usage.

Additional query words: Performance OLAP Design BIHowto

Keywords: kbinfo KB304155

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.