3.1.4.2.2.1.3.60.1 Columns

The DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS rowset contains the following columns.

Name

Type

Restriction

Description

DATABASE_NAME

xsd:string

Yes<307>

The name of the database.

CUBE_NAME

xsd:string

Yes<308>

The name of the cube.

MEASURE_GROUP_NAME

xsd:string

Yes<309>

The name of the measure group.

DIMENSION_NAME

xsd:string

The name of the dimension.

TABLE_ID

xsd:string

The ID of the table.

COLUMN_ID

xsd:string

The ID of the column.

SEGMENT_NUMBER

xsd:long

The numeric value of the segment.

TABLE_PARTITION_NUMBER

xsd:long

The numeric value of the partition table.

RECORDS_COUNT

xsd:long

The number of records.

ALLOCATED_SIZE

xsd:unsignedLong

The size of allocated data.

USED_SIZE

xsd:unsignedLong

The size of the data used.

COMPRESSION_TYPE

xsd:string

The type of compression. Currently, this value is always "NOSPLIT". The compression value is intended for internal server use only.

BITS_COUNT

xsd:long

The count of bits required to store the Data IDs.

BOOKMARK_BITS_COUNT

xsd:long

The bookmark count of BITS.

VERTIPAQ_STATE

xsd:string

The state of the VertiPaq compression for this column segment. The value is one of the following:

  • COMPLETED – The VertiPaq compression completed successfully.

  • TIMEBOXED – The VertiPaq compression was timeboxed.

  • SKIPPED – The VertiPaq compression was skipped.

ISPAGEABLE

xsd:boolean

When true, MAY<310> indicate that the segment is pageable; otherwise, false. If the paging feature is not supported on the server, the value is NULL.

ISRESIDENT

xsd:boolean

When true, MAY<311> indicate that the segment is resident; otherwise, false. If the paging feature is not supported on the server, the value is NULL.

TEMPERATURE

xsd:double

When the segment is pageable and is resident, MAY<312> indicate the scaled numeric value of the frequency of segment access considering the last access time and usage; otherwise, NULL.

LAST_ACCESSED

xsd:datetime

For a pageable segment, MAY<313> indicate the last access time of a segment if it has been paged in at least once; otherwise, NULL. For a non-pageable segment, the value is always NULL.

The rowset is not sorted.

The response has the following definition.

       <xsd:element name="root">
         <xsd:complexType>
           <xsd:sequence minOccurs="0" maxOccurs="unbounded">
             <xsd:element name="row" type="row" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="DATABASE_NAME" name="DATABASE_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="MEASURE_GROUP_NAME" name="MEASURE_GROUP_NAME" 
                        type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DIMENSION_NAME" name="DIMENSION_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="TABLE_ID" name="TABLE_ID" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="COLUMN_ID" name="COLUMN_ID" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="SEGMENT_NUMBER" name="SEGMENT_NUMBER" type="xsd:long" 
                        minOccurs="0" />
           <xsd:element sql:field="TABLE_PARTITION_NUMBER" name="TABLE_PARTITION_NUMBER" 
                        type="xsd:long" minOccurs="0" />
           <xsd:element sql:field="RECORDS_COUNT" name="RECORDS_COUNT" type="xsd:long" 
                        minOccurs="0" />
           <xsd:element sql:field="ALLOCATED_SIZE" name="ALLOCATED_SIZE" 
                        type="xsd:unsignedLong" minOccurs="0" />
           <xsd:element sql:field="USED_SIZE" name="USED_SIZE" type="xsd:unsignedLong" 
                        minOccurs="0" />
           <xsd:element sql:field="COMPRESSION_TYPE" name="COMPRESSION_TYPE" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="BITS_COUNT" name="BITS_COUNT" type="xsd:long" 
                        minOccurs="0" />
           <xsd:element sql:field="BOOKMARK_BITS_COUNT" name="BOOKMARK_BITS_COUNT" 
                        type="xsd:long" minOccurs="0" />
           <xsd:element sql:field="VERTIPAQ_STATE" name="VERTIPAQ_STATE" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="ISPAGEABLE" name="ISPAGEABLE" type="xsd:boolean" 
                        minOccurs="0" />
           <xsd:element sql:field="ISRESIDENT" name="ISRESIDENT" type="xsd:boolean" 
                        minOccurs="0" />
           <xsd:element sql:field="TEMPERATURE" name="TEMPERATURE" type="xsd:double" 
                        minOccurs="0" />
           <xsd:element sql:field="LAST_ACCESSED" name="LAST_ACCESSED" type="xsd:datetime" 
                        minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>