Why not do distinct before SetOp

Поиск
Список
Период
Сортировка
От ma lz
Тема Why not do distinct before SetOp
Дата
Msg-id TYCPR01MB63514B9C70EF2A80F0D43394F2512@TYCPR01MB6351.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответы Re: Why not do distinct before SetOp
Список pgsql-general
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?

В списке pgsql-general по дате отправления: