MicroStrategy ONE
STG_IS_CACHE_HIT_STATS
Tracks job executions that hit the report cache. This table is used when the Basic Statistics option is selected in the Statistics category of the Project Configuration Editor. The data load process moves this table's information to the IS_CACHE_HIT_STATS table, which has the same columns and datatypes.
| Column | Description | SQL Server Data-type | Oracle Data-type | DB2 Data-type | Teradata Data-type | Sybase Data-type | MySQL Data-type |
|
DAY_ID |
Day the job execution hit the report cache. |
DATE |
TIMESTAMP |
DATE |
DATE |
DATE |
DATE |
|
HOUR_ID |
Hour the job execution hit the report cache. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
MINUTE_ID |
Minute the job execution hit the report cache. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
CACHEINDEX (I) |
A sequential number for this table. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
CACHESESSIONID (I) |
GUID of the user session. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERID |
GUID of the server definition. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
CACHEHITTIME (I) |
Timestamp when this cache is hit. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
CACHEHITTYPE (I) |
Type of cache hit: 0: Report cache hit 1 or 2: Document cache hit |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
CACHECREATORJOBID (I) |
Job ID that created the cache. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
CREATORSESSIONID (I) |
GUID for the session in which cache was created. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
JOBID (I) |
Job ID for partial cache hit, or document parent job ID if the cache hit originated from document child report. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
STARTTIME |
Timestamp of when the job started. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
RECORDTIME (I) |
Timestamp of when the record was written to the database, according to database system time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
SERVERMACHINE |
(Server machine name:port number) pair. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
PROJECTID (I) |
GUID of the project. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
REPOSITORYID |
GUID of the metadata repository. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
The table below lists combinations of CACHEHITTYPE and JOBID that can occur in the STG_IS_CACHE_HIT_STATS table and what those combinations mean.
| Cache Hit Type | JobID | Description |
|
0 |
-1 |
For a normal report, a full cache hit |
|
0 |
Real JobID |
For a normal report, a partial cache hit |
|
1 |
Parent JobID |
For a child report from a document, a full cache hit, so no child report |
|
2 |
Child JobID |
For a child report from a document, a partial cache hit, child report has a job |