开发者

btree in btree with mysql or postgres

开发者 https://www.devze.com 2023-02-13 04:37 出处:网络
does mysql and/or postgres have small btrees in the leafs of the btree? Say I am using an index over multiple columns, then that would be a nice feature to have.

does mysql and/or postgres have small btrees in the leafs of the btree? Say I am using an index over multiple columns, then that would be a nice feature to have.

Or is the key in the index only a delimiter separa开发者_StackOverflowted thing?


Not sure about Postgres, but no, MySQL doesn't use nested B-Trees. I believe multi-column indexes are just treated like the two values are concatenated. Here's a good article about the MySQL B-tree implementation.

0

精彩评论

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

关注公众号