0
Follow
0
View

Mysql uses string type to generate primary key, index how to go?(Language -java)

duanweiye 注册会员
2023-02-27 18:32

id is a string, the string can also be sorted, the simplest is to use the dictionary order, so the database using the string as the index can also greatly improve the efficiency of the query.

cs15001 注册会员
2023-02-27 18:32

also walk index, do not walk full table scan. The
suggestion is to define a separate field for the id, add an index to it, and use MySQL to increment the ID.

About the Author

Question Info

Publish Time
2023-02-27 18:32
Update Time
2023-02-27 18:32

Related Question

Cloud_firestore /使用颤振拒绝许可

Python将数据加载到MySQL: AttributeError: 'tuple'对象没有属性'encode'

为什么Gitee Pages用不了apple-touch-icon

Matlab Optimization Toolbox怎么安装?

tomcat启动后报错

motohawk如何使用rs485串口

我如何从Java程序发送消息到Javascript STOMP客户端使用ActiveMQ-Artemis?

Jakarta ConcurrentModificationException或IndexOutOfBoundsException

谷歌oauth2Client.getToken不会为其他用户返回id_token

MySQL数据导入向导非常慢