SQL statement analysis is a detailed account for the selected SQL structure, per database.  The SQL statement analysis gives us unique information relative to each query falling under the selected SQL statement structure. ScaleArc allows you to add the unique query to as a cache or a firewall cache rule.

View a unique query

1. Click on the Analytics tab. Select the time period.
2. Select the cluster and the hour.
3. Hover over a database server.
4. View the query pattern grid.
5. Click on a query pattern to open the screen for unique queries. 
   
   
   
   
6. The graph saws the total unique queries for the specified period and the time to process them on the server(s). Select a different time period at any time in this process to see the unique queries in that period. Note that the new time period may not have any queries. The queries may be broken down pages, if the list too long.

7. You can add the unique query as a cache or firewall rule. You need to add each query, one at a time.

   If you have not added the database referenced in the query pattern in Users and DBs, you cannot create a cache rule for the query pattern. Instead, you will receive an error notification.

8. Click Cache to open the popup in the grid detail to add the query as a cache rule. 
   
   
   
   
   1. The selected query appears in the query field. 
   2. Enter an appropriate value for TTL (Time-To-Live) from the drop down.
   3. Turn on cache rule.
   4. Select the appropriate radio button to save the query as a query cache or as a stored procedure cache.
   5. Click Add to save it. 
       
9. Alternatively, click Firewall on the Query detail in the grid to add it as a firewall rule.

1. 
   
   
   1. The selected query appears in the query field. 
   2. Turn on firewall status.
   3. Click Add to save it.