MySQL 聚合索引实例_1:mysql 聚合索引

最新推荐文章于 2022-10-07 20:58:47 发布

焦虑中

最新推荐文章于 2022-10-07 20:58:47 发布

阅读量89

点赞数

文章标签： MySQL 聚合索引实例

本文链接：https://blog.csdn.net/weixin_28681379/article/details/113261960

版权

1：

PRIMARY KEY (`id`),

UNIQUE KEY `uid` (`uid`,`task_id`)

查询：

mysql> explain select * from user_task where uid = 232;

+----+-------------+-----------+------+---------------+------+---------+-------+------+-------+

+----+-------------+-----------+------+---------------+------+---------+-------+------+-------+

| 1 | SIMPLE | user_task | ref | uid | uid | 4 | const | 206 | |

+----+-------------+-----------+------+---------------+------+---------+-------+------+-------+

mysql> explain select * from user_task where task_id = 1454;

+----+-------------+-----------+------+---------------+------+---------+------+-------+-------------+

+----+-------------+-----------+------+---------------+------+---------+------+-------+-------------+

+----+-------------+-----------+------+---------------+------+---------+------+-------+-------------+

1 row in set (0.00 sec)

mysql> explain select * from user_task where task_id = 1454 and uid = 232;

+----+-------------+-----------+-------+---------------+------+---------+-------------+------+-------+

+----+-------------+-----------+-------+---------------+------+---------+-------------+------+-------+

| 1 | SIMPLE | user_task | const | uid | uid | 8 | const,const | 1 | |

+----+-------------+-----------+-------+---------------+------+---------+-------------+------+-------+

1 row in set (0.00 sec)

如果(a， b, c)

查询a ； a b ； a b c 会用到索引

所以建立索引的时候如果要查询 b c 那么可以 key(b, c)

KEY 和index 不同的是 key 可以有约束同时会有索引

关注