HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

Supported Versions:

Other Versions:

Usage Guide

  1. Set the GUC parameter default_statistics_target to an integer ranging from [-100, -1], which indicates the sampling rate.
  2. Use ANALYZE(([column_name,])) to collect data statistics and create models.
  3. Enter a query. If a statistical model is created on the equality query column involved in the query, the statistical model is automatically used to estimate the selection rate.
  4. When the intelligent statistics model is no longer needed, you can use ALTER TABLE [table_name] DELETE STATISTICS (([column_name,])) to collect statistics and delete the model.

For details about other methods, see sections ALTER TABLE and ANALYZE | ANALYSE

Copyright © 2011-2024 www.enmotech.com All rights reserved.