alibaba / alibaba/p3c

Mysql数据库-见表规约-14条

Open
#925 0 comments 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.