Indexes, Columns, Rows in Application Logging Tables
Indexes in Application logging tables include a:
- Primary key index on the joined timestamp and sequence number columns.
- Secondary key index on the joined timestamp_utc and sequence number columns.
- Secondary index on the timestamp alone.
- Secondary index on the timestamp_utc alone.
If you have selected the project name table attribute, the primary key index also includes the project name column.
Columns in Application logging tables include:
- Columns that are specific to that table.
- An additional column for each table attribute you have selected.
Rows in all Application logging tables include:
- A timestamp column.
- A timestamp_utc column
- An auto increment sequence number that ensures that each row is unique.