30
单表近 7 亿条数据，现在要优化结构，进行去重，求个方案
source link: https://www.v2ex.com/t/676577
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
数据库 - @FONG2 - 以前设计是以请求编号为主键的，现在优化后以用户编号为主键，那么就存在大量重复数据了。现在用 sql 查一下都得等半天，请问有啥好方法处理么
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK