Query Performance, Workload Management, and Statistics
This section includes information schema views that contain statistics and other data which are useful for monitoring and improving query performance, as well as managing the workload of a cluster.
In this section
- ADVANCED_HISTOGRAMS
- AGGREGATE_FUNCTIONS
- COLUMN_STATISTICS
- INDEX_STATISTICS
- LMV_ASYNC_COMPILES
- LMV_JOIN_OPTIMIZATION_RESULTS
- information_schema.LMV_LOCAL_DATABASES
- LMV_PROFILE_STATS
- MV_BACKUP_HISTORY
- MV_BACKUP_STATUS
- MV_BT
- MV_PLANCACHE
- MV_PROCESSLIST
- MV_PROSPECTIVE_HISTOGRAMS
- MV_QUERY_PROSPECTIVE_HISTOGRAMS
- MV_WORKLOAD_MANAGEMENT_STATUS
- OPTIMIZER_STATISTICS
- PLANCACHE
- RANGE_STATISTICS
- STATISTICS
- TABLE_STATISTICS and INTERNAL_TABLE_STATISTICS
- USER_VARIABLES
- WORKLOAD_MANAGEMENT_QUEUE
Last modified: July 30, 2024