|
some sql like ' select a from t1 intersect select a from t1 '
if t1 has large number rows but has few distinct rows
select distinct a from t1 intersect select distinct a from t1; ― this is faster than origin sql
can postgres do this optimize during plan-queries?
|
