O'Reilly logo

Actian Matrix (Formely ParAccel) - Architecture and SQL by Ed Bernier, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required