To print or view information stored in the Activity Log
The following information may be displayed according to the selected criteria.
|
Item |
Description |
|---|---|
|
The user name from the PC | |
|
Logon User |
Database logon name |
|
Database Alias |
Database alias name |
|
Schema |
Schema name |
|
Item |
Description |
|---|---|
|
Date |
Date and time when the activity was executed. |
|
Activity |
The type of activity recorded: OP – SQL Optimization EP – Access Plan Generation |
|
The classified type of the original SQL statement. For example: Simple, Complex or Problematic. The SQL type is dependent on the Options settings. | |
|
Current status of the activity relating to run time for all records. | |
|
Original SQL Elapsed Time (All Records) |
Run time for retrieving all the records of the original SQL statement. |
|
Run time for the SQL alternative that has the best alternative run time for all records. | |
|
Times of Improvement (All Records) |
The number of times faster the best alternative SQL is compared with the original SQL statement when comparing the run times for all records. |
|
Status (First Record) |
Current status of the activity relating to run time for the first record. |
|
Original SQL Elapsed Time (First Record) |
Run time for retrieving the first record of the original SQL statement. |
|
Best Alternative Elapsed Time (First Record) |
Run time for the first record from the SQL alternative that has the best alternative run time for the all records. |
|
Times of Improvement (First Record) |
The number of times faster the best alternative SQL is compared with the original SQL statement when comparing the run times for the first record. |
Note: The Activity Log information will be retrieved from the Activity Log directory. Therefore if any changes have been made to this directory, the information may not be retrieved.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
