indices on tab1.a=tab2.a

Поиск
Список
Период
Сортировка
От admin
Тема indices on tab1.a=tab2.a
Дата
Msg-id Pine.BSF.4.10.10001121250410.68208-100000@server.b0x.com
обсуждение исходный текст
Список pgsql-general
I have unfortunately deleted a message to pgsql-general today which
contained a query like:

SELECT tab1.b, tab2.c FROM tab1, tab2 WHERE tab1.a=tab2.a;

There was also a UNION following, but my memory fails me. My question is
though, can an index be used for the above query? When I try it with an
index on tab1.a and tab2.a, I get two hash joins and two seq scans.

If there's any way to optimise this query, please let me know,
Marc


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

Предыдущее
От: Mike Mascari
Дата:
Сообщение: Re: [GENERAL] Simulating an outer join
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [GENERAL] identifying performance hits: how to ???