pingcap / pingcap/tidb

wrong estimation causing wrong plan in TPCDS

Open
#39,520 0 comments 0 reactions 0 assignees View on GitHub
epic/cardinality-estimation sig/planner type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement
Q53 and Q63
![1ff019c6-58ae-469e-b6ed-06bfe067fb0c](https://user-images.githubusercontent.com/7499936/204844693-fd42b824-2f37-4c50-a792-a0a72d498851.jpeg)

Contributor guide

Open the contributing guide

Research direction

The issue names no files, tests, or entry points. Begin with TPC-DS Q53 and Q63 and the attached plan output; reproduce both queries, trace the estimation and plan-selection path, and confirm that corrected estimates produce the expected plans.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases, performance
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.