Please enable JavaScript to view this site.

Data Cache Data Model

Navigation: » No topics above this level «

dc_physical_statistics: Data Cache Physical Statistics

 Contents Previous Home Next More

Statistics on the physical storage.

Catalog: Cache

Schema: Invantive

Alias: psc

Label: Physical Statistics

This is a read-only view. The Data Cache API may not support changing the data or the Invantive SQL driver for Data Cache does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Cache API.

View Columns

The columns of the view dc_physical_statistics are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

index_space_mb

decimal

Index Space (MB)

☑

Estimated storage allocated in MB by indexes of physical table.

row_count

decimal

Rows

☑

Estimated number of rows in physical table.

table_name

string(240)

Table Name

☑

Name of physical table.

table_space_mb

decimal

Table Space (MB)

☑

Estimated storage allocated in MB by physical table.

 

09-12-2020 18:57 Version 20.1.300-BETA+3020