I have two more datasets, one dataset data has millions of data, and one dataset has only a few data, it takes usually more than ten minutes to unionize these two datasets, why is it like this, is there any optimization solution?

select * from tableA —– million data
union all
select * from tableB —– 10 pieces of data

Any data set query is fast
but it’s slow when two datasets are united.