Skip to content

Increase the analyze options upper limit to accommodate table with large row count and NDV #50597

@time-and-fate

Description

@time-and-fate

Enhancement

Currently, the upper limit for the statistics collection option is 1024 histogram buckets and 16384 topn entries.

In some extreme scenarios, we want to make it higher to accommodate tables with very large row count and NDV and overcome some limitations and shortcomings in our estimation strategy.

So we need to increase the upper limit.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions