Data Virtualization Managers can view, search, and filter queries that were run in the service.

To manage data queries, follow these steps.

• Specify a time range to get a list of queries.
  By specifying a time range, you can drill down the number of queries and find queries that are of interest to you.
  1. On the navigation menu, click Data > Data virtualization.
  2. Click Virtualization > Cache management > Queries.
  3. In the Time range menu, select the time range.
     You can view a list of queries that ran on the specified time range in Data Virtualization.
• Click the SQL text in the cell to see query details and get an overview of query performance.
  The query bar chart provides details about the responsiveness and execution time of the query. Additionally, you can compare queries that are using a cache and queries that are not using a cache.
• To view the statement of a query, click View query.
• To create a cache from a query, click Query ID > View query > Create cache and follow steps 5 - 7 in Adding data caches.
  Restriction: Cache entries are subject to certain restrictions in Data Virtualization. For more information, see Restrictions for cache entries.
• Select how you want to sort queries.
  • Average response time without a cache
  • Average response time with a cache
  • Total executions
  • Executions using cache
• Select how you want to filter queries.
  You can filter queries by:

  • Including or excluding Queries using data caches.
  • Response time range.
  • Selecting Data caches.
  • Selecting Users that created queries.