The sa_diagnostic_auxiliary_catalog table is owned by the dbo user, and is used to map database objects between the production database and tracing database. Objects include user tables, procedures, and functions. This table is used primarily by the Index Consultant and the TRACED_PLAN function.
Columns| Column name | Column type | Description |
|---|---|---|
| original_object_id | UNSIGNED BIGINT |
The object ID of this object in the main tracing database. |
| local_object_id | UNSIGNED BIGINT |
The object ID of this object in the auxiliary tracing database. |
| pages_if_table | UNSIGNED INT |
If the object is a table, this is the number of pages in the table. If the object is not a table, this value is NULL. |
| rows_if_table | UNSIGNED BIGINT |
If the object is a table, this is the number of rows in the table. If the object is not a table, this value is NULL. |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |