mysql not in 如何进行性能优化

Question

如何优化mysql not in :
语句：
select A.* from A where A.id not in (
select B.aid from B where B.id !=1
)

Answer 1

not exists