Mysql数据库-见表规约-14条
Open
- Dominant language
- Kotlin
- Stars
- 30.8k
- Forks
- 8k
- PR merge metrics
- No merged PRs in 30d
Description
## 规约原文
```
【推荐】字段允许适当冗余,以提高查询性能,但必须考虑数据一致。冗余字段应遵循:
1)不是频繁修改的字段。
2)不是唯一索引的字段。
3)不是 varchar 超长字段,更不能是 text 字段。
正例:各业务线经常冗余存储商品名称,避免查询时需要调用 IC 服务获取。
## 问题描述
遵循第2项:不是唯一索引的字段。
这个是为什么呢?
## 修改建议
Contributor guide
No contributing guide indexed for this repository
Research direction
The issue quotes the MySQL redundancy guideline and asks why unique-indexed fields are excluded. Start by reviewing the quoted rule and its surrounding documentation; done means documenting a clear rationale or deciding that no guideline change is needed.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql
- Domain
- databases
- Issue type
- Documentation
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100