关于Mysql-据库索引总结1-使用索引的注意事项中，“加索引的列设置为 NOT NULL ，而进行全表扫描”
Navigation Menu
{{ message }}
Snailclimb / JavaGuide Public
- Notifications You must be signed in to change notification settings
- Fork 46.1k
Closed
Description
opened
on Apr 28, 2020加索引的列设置为 NOT NULL ，否则将导致引擎放弃使用索引而进行全表扫描
经过试验把某一列设置为default null，where是可以走索引
Metadata
Metadata
Assignees
No one assigned
Projects
No projects
Milestone
No milestone
Relationships
None yet
Development
No branches or pull requests
Issue actions