ILD

multiple column primary key search one column performance
作者:Yuan Jianpeng 邮箱:yuanjp89@163.com
发布时间:2025-5-21 站点:Inside Linux Development

有一张表,它的主键是2列组成。那么搜索第一列是有索引效果的。第二列就没有。个人理解


参考

Does SQLite multi column primary key need an additional index?

https://stackoverflow.com/questions/3056367



Copyright © linuxdev.cc 2017-2024. Some Rights Reserved.