INFO.STORAGETABLECOLUMNSEGMENTS DAX Function (Information)

Syntax  |  Return values  |  Remarks  

Returns information about the column segments used for storing data for in-memory tables.

Syntax

INFO.STORAGETABLECOLUMNSEGMENTS ( [<RestrictionName> [, [<RestrictionValue>] [, <RestrictionName> [, [<RestrictionValue>] [, … ] ] ] ] ] )

Parameter	Attributes	Description
RestrictionName	Optional Repeatable	Restriction name.
RestrictionValue	Optional Repeatable	Restriction value.

Return values

Table An entire table or a table with one or more columns.

Field	Type
DATABASE_NAME	String
CUBE_NAME	String
MEASURE_GROUP_NAME	String
PARTITION_NAME	String
DIMENSION_NAME	String
TABLE_ID	String
COLUMN_ID	String
SEGMENT_NUMBER	Integer
TABLE_PARTITION_NUMBER	Integer
RECORDS_COUNT	Integer
ALLOCATED_SIZE	Integer
USED_SIZE	Integer
COMPRESSION_TYPE	String
BITS_COUNT	Integer
BOOKMARK_BITS_COUNT	Integer
VERTIPAQ_STATE	String
ISPAGEABLE	Boolean
ISRESIDENT	Boolean
TEMPERATURE	Decimal
LAST_ACCESSED	DateTime

Remarks

Corresponds to the DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS data management view (DMV).

As all the INFO functions, it cannot be used in calculated tables and calculated columns.

Last update: Nov 14, 2024   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation not available.
The function may be undocumented or unsupported. Check the Compatibility box on this page.