开发者

Nulls in InnoDBs clustered index?

开发者 https://www.devze.com 2023-03-13 11:51 出处:网络
Using InnoDB in MySQL, I want to speed up selects by utilizing the clustered index better, thus including more frequently used columns in the primary key.

Using InnoDB in MySQL, I want to speed up selects by utilizing the clustered index better, thus including more frequently used columns in the primary key.

But some frequent columns used are allowed to be null (and some times are). Is there any way to include these i开发者_StackOverflow社区n the clustered index (and allow them to be null)?

If not, are there some workarounds or is there some other way to do something similar?


Normalizing the table to exclude the nullable field would work in this case (as commented by Battle_707).

0

精彩评论

暂无评论...
验证码 换一张
取 消