Understanding Query Administration


Concept


Steps:

  1. Use the Query Administration- Admin page to monitor query performance and usage.

    Step 1
  2. In the Query Administration- Admin page, you can use either the predefined search or manual search option to restrict the list of queries that are displayed.

    Step 2
  3. For a predefined search, enter the desired value for the search option in the (n)= field, and select one of the options in the Choose a predefined search field.

    Step 3
  4. For a manual search, select to search queries by query name or owner ID.

     

    You can define your search further by selecting either begins with or contains search type.

    Step 4
  5. Click the Search button to display a list of queries that match your search criteria.

    Step 5
  6. After you click the Search button, the Query List group box lists those queries that match your search criteria.

    Step 6
  7. Select the Select check box for each query on which you want to perform an action.

    Step 7
  8. You can also click the Check All button to select all queries, or click the Uncheck All button to clear all queries.

    Step 8
  9. For the appropriate query, click the View SQL link to view the SQL for that query.

    Step 9
  10. For the appropriate query, click the View Log link to view the log for that query.

    Step 10
  11. Click the Logging On button to enable logging for the selected query.

    Step 11
  12. Click the Logging Off button to disable logging for the selected query.

    Step 12
  13. Click the Enable button to enable the selected query to be run, previewed, or scheduled.

    Step 13
  14. Click the Disable button to disable the selected query from being run, previewed, or scheduled.

    Step 14
  15. Click the Assigns New Owner button to assign a new owner to the selected query.

    Step 15
  16. Click the Delete button to delete the selected query.

    Step 16
  17. Click the Rename button to rename the selected query.

    Step 17
  18. Click the Move to Folder button to move the selected query to a folder.

    Step 18
  19. Click the Clears Stats/Logs button to delete the statistics and logs for the selected query.

    Step 19

You have successfully reviewed the Understanding Query Administration topic.

Table of Contents  Start Topic