System administrators can use Query Administration to monitor query performance and usage. Some of the conditions that you can monitor include average runtime, number of times run, and the dates last run. Using a predefined search, you can also select queries to review and report on.

 

Query Administration also enables you to cancel queries that are currently running in Query Manager and Query Viewer as well as enable and disable queries and logging.

 

Upon completion of this lesson, you will be able to:

• Describe Query Administration.

• Describe how to cancel currently running query.

• Describe additional query options.


Table of Contents