Important
New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.
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
- CORRELATED_COLUMN_STATISTICS
- INDEX_STATISTICS
- LMV_ASYNC_COMPILES
- LMV_CONNECTION_ATTRIBUTES
- LMV_JOIN_OPTIMIZATION_RESULTS
- LMV_LOCAL_DATABASES
- LMV_PROFILE_STATS
- MV_ACTIVE_DISTRIBUTED_TRANSACTIONS
- MV_BACKUP_HISTORY
- MV_BACKUP_STATUS
- MV_BT
- MV_CONNECTION_ATTRIBUTES
- MV_FTS_MERGED_INDEXES
- MV_FULLTEXT_INDEXES
- 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
- VECTOR_INDEX
Last modified: