使用子查询提高SQL性能?

Question

我有两个表，结构如下:

事务

tbody> <<tr>2

id	transaction_date	amount
1	2022-03-01	50
	2022-04-01	25

如果tags(transaction_id,name)是唯一的，那么尝试2连接是否会更好

select
transaction_date,
sum(amount),
t1.value as account,
t2.value as sku
from 
transactions 
left join
tags t1 on transactions.id = t1.transaction_id and t1.name ='account'
left join
tags t2 on transactions.id = t2.transaction_id and t2.name = 'sku'
group by
transaction_date,
t1.value,
t2.value;