Meituan-Dianping / Meituan-Dianping/SQLAdvisor
针对无where条件的SQL，不能给出优化建议
Open
Nobody has claimed this yet.
- Dominant language
- C
- Stars
- 5.6k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
select max(num) from tbname;
select distinct A from tbname;
select title,count(*) from tbname group by title;
类似的没有where条件的sql，不能给出优化建议，SQL也不逆天：）
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the three SQL examples with SQLAdvisor and trace how statements without WHERE clauses are handled. The issue names no files or tests, so first determine the expected optimization advice for the aggregate, DISTINCT, and GROUP BY queries before identifying the relevant code and verification path.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- c, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100