大家好,现在遇到一个问题, 有三张表,分别是A,B,C, 都有相关的主键;
MYSQL版本 : 5.7.17 linux
创建一个视图: VIEW1
create view1 as
SELECT aid uuid, col2,col3,col4 FROM A
union all
SELECT bid uuid, col2,col3,col4 FROM B
union all
SELECT cid uuid, col2,col3,col4 FROM C;
按照UUID查询
SELECT * FROM view1 WHERE uuid='xxxx';
explain的执行计划为
+----+-------------+-----------------+------------+------+---------------+-------------+---------+-------+------+----------+-------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+-----------------+------------+------+---------------+-------------+---------+-------+------+----------+----