Computing Table Statistics

Arcadia Enterprise enables you to compute the statistics of data tables that are available through established connections.

To update the statistics for a table available through the connection, click Compute Statistics next to the table name (here, census_pop). A Success modal window appears.

The results of the update appear under the Table Statistics and Column Statistics tabs.

updating statistics on table
Computing the Table and Column Statistics in Connection Explorer

Table Statistics

[For Arcadia connections only]

Click the Table Statistics tab, and note the information reported for the table: #Rows, #Files, Size, Bytes Cached, Cache Replication, Format, Incremental stats, and Location of the table.

exploring table data in connection explorer
Table Statistics in the Connection Explorer

Column Statistics

[For Arcadia connections only]

Click the Column Statistics tab, and note the information reported for data characteristics in the table: Column, Type, #Distinct Values, Max Size, and Avg Size.

exploring column statistics
Column Statistics in the Connection Explorer