The ARF_QUERY_MV_HOUR
view provides aggregated data about queries that are submitted to ATG Search. The calculated values are based on information in the ARF_QUERY
table. The values in each row are constrained to a particular hour, day, site, language, and query type.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| numeric | Yes | The number of search queries that correspond to the hour, day, site, language, and query type. This value counts rows in the | |
| varchar | 40 | No | A reference to a value in the |
| timestamp | No | A reference to a value in the | |
| smallint | No | A reference to a value in the | |
| smallint | No | A reference to a value in the | |
| tinyint | No | A reference to a value in the | |
| tinyint | No | A reference to a value in the | |
| numeric | Yes | The total length, in milliseconds, of the processing time for search queries for the hour, day, site, language, and query type. This value sums | |
| numeric | Yes | The total number of search query results returned for the hour, day, site, language, and query type. This value sums | |
| numeric | Yes | The total relevancy score of search query results for the hour, day, site, language, and query type. This value sums | |
| numeric | Yes | The lowest length, in milliseconds, of the processing time for search queries for the hour, day, site, language, and query type. This value is the minimum | |
| numeric | Yes | The longest length, in milliseconds, of the processing time for search queries for the hour, day, site, language, and query type. This value is the maximum | |
| numeric | Yes | The lowest relevancy score in search query results for the hour, day, site, language, and query type. This value is the minimum | |
| numeric | Yes | The highest relevancy score in search query results for the hour, day, site, language, and query type. This value is the maximum |