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<337> |
The name of the database. |
|
CUBE_NAME |
xsd:string |
Yes<338> |
The name of the cube. |
|
MEASURE_GROUP_NAME |
xsd:string |
Yes<339> |
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:
|
|
ISPAGEABLE |
xsd:boolean |
|
When true, MAY<340> 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<341> 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<342> 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<343> 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>