Database Statistics Sampling Parameters

These parameters adjust the amount of data sampled by an ANALYZE operation. Adjusting these parameters affects statistics collection system-wide. You can configure statistics collection on particular tables and columns by using the ALTER TABLE SET STATISTICS clause.

  • default_statistics_target
  • gp_analyze_relative_error

Parent topic: Query Tuning Parameters

check-circle-line exclamation-circle-line close-line
Scroll to top icon