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.
[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.
[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.