Data Vault Administrator Guide

6.5
- 6.5.1
- 6.5 HotFix 1
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Viewing Table Statistics

You can view the archive statistics for a table, including the number of partitions and the compression ratio.

To view the archive statistics for a table, select the name of a table in the

Tables

node. The information pane displays the archive statistics for the selected table.

The following table describes the summary information that is displayed for a table:

Property	Description
Table	Database, schema, and table name of the table in the format "DatabaseName"."SchemaName"."TableName".
ID	Table identifier assigned by the Data Vault Service.
DB	Name of the database that contains the table. The database name in the Data Vault repository is the same as the database name in the archive source.
Schema Name	Name of the schema associated with the database that contains the table.
Table Name	Name of the selected table.
Type	Type of table based on the data files the table contains. A table can be one of the following types: Archive table Updatable table

The Data Vault Service displays data file information for Updatable tables but not for Archive tables. For example, the Data Vault Service displays the size of the data files for an Updatable table but not for an Archive table

The following table describes the detailed statistics displayed for a table:

Property	Description
ID	Table identifier assigned by the Data Vault Service.
Name	Schema and table name of the table in the format "SchemaName"."TableName".
Type	Type of table based on the data files the table contains. A table can be one of the following types: Archive table Updatable table
Columns	Number of columns in the selected table.
System Columns	Number of system columns in the selected table. The Data Vault Service uses system columns internally for storing metadata. This property does not display for a table of type Archive.
Row Length	Maximum length that a row can have in the selected table. The length of the row is based on the size of the columns in the table. Displayed in bytes.
Partitions	Number of partitions in the table.
Files	Number of data files registered for the selected table.
Total size (Archive)	Size of the archive data portion of the compressed data in the table. Archive files contain the data portion of the table. This property does not display for a table of type Archive.
Total size (Update)	Size of the metadata portion of the compressed data in the table. Update files contain the metadata portion of the table. The Data Vault Service adds to the update files when you perform Data Archive tasks such as setting up legal holds. This property does not display for a table of type Archive.
Total size (Arc/Upd)	Size of archive and update data files as a percentage of the total table size. This property does not display for a table of type Archive.
Total size	Total size of the compressed data in the selected table.
Total rows	Total number of rows in the selected table.
Flat file size (Archive)	Size of the archive data portion of the uncompressed BCP data. The Data Vault Service uses the bulk copy program (BCP) utility to transfer uncompressed source data to the optimized file archive. This property does not display for a table of type Archive.
Flat file size (Update)	Size of the metadata portion of the uncompressed BCP data. This property does not display for a table of type Archive.
Flat file size (Arc/Upd)	Size of the data and metadata portion as a percentage of the total size of the uncompressed BCP data. This property does not display for a table of type Archive.
Flat file size	Size of the uncompressed BCP data for the selected table.
Compression ratio	Estimated degree of data compression in the selected table.

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

Viewing Table Statistics

Viewing Table Statistics