Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

PR #98229 - opt: add setting to always use histograms to calculate stats #16447

Open
cockroach-teamcity opened this issue Mar 9, 2023 · 1 comment
Open

PR #98229 - opt: add setting to always use histograms to calculate stats #16447

cockroach-teamcity opened this issue Mar 9, 2023 · 1 comment
Assignees
@taroface
Labels
C-product-change release-22.1

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Mar 9, 2023 •
edited by exalate-issue-sync bot
Loading

Exalate commented:

Related PR: cockroachdb/cockroach#98229
Commit: cockroachdb/cockroach@5813842
Informs: cockroachdb/cockroach#64570

Release note (sql change): Added a new session setting,
optimizer_always_use_histograms, which ensures that the optimizer
always uses histograms when available to calculate the statistics
of every plan that it explores. Enabling this setting can prevent
the optimizer from choosing a suboptimal index when statistics for
a table are stale.

Jira Issue: DOC-7156
@exalate-issue-sync
Copy link

Mike Lewis (mikeCRL) commented:
Routed to SQL Queries based on cockroach package https://cockroachlabs.atlassian.net/wiki/spaces/ED/pages/2934931562/Routing+issues+to+Product+Areas

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@taroface taroface

Labels
C-product-change release-22.1
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@taroface @cockroach-teamcity