Chapter 3 – Systems Tables

“He who asks a question may be a fool for five minutes, but he who never asks a question remains a fool forever.”

- Unknown

Actian Matrix System Tables

Actian Matrix provides access to the following types of system tables:

STL tables for logging - These system tables are generated from Actian Matrix log files to provide a history of the system. Logging tables have an STL prefix.

STV tables for snapshot data - These tables are virtual system tables that contain snapshots of the current system data. Snapshot tables have an STV prefix.

System views - System views contain a subset of data found in several of the STL and STV system tables. Systems views have an SVV or SVL prefix.

System catalog tables - The system ...

Get Actian Matrix (Formely ParAccel) - Architecture and SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.