Using Table Indexes After Joins

Поиск
Список
Период
Сортировка
От Alex Koay
Тема Using Table Indexes After Joins
Дата
Msg-id CAG+qcA5xAnuuDMkbS1PR+w9BDHj=+gF=a-O951rNGcjkYZc6-A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Using Table Indexes After Joins  (Willy-Bas Loos <willybas@gmail.com>)
Список pgsql-novice
Is it possible to use the original table indexes after a join?

I have a query like this:
SELECT lag(bar.d, 1) OVER (foo.a, foo.b, foo.c) FROM foo NATURAL JOIN bar

with an index on foo(a,b,c), but it doesn't seem to use the index for
the sort pre-window.
Note that foo and bar have a strict one-to-one relationship.

In such a case, would it be more advisable to use one single table instead?

Regards,
Alex

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

Предыдущее
От: Jim Moon
Дата:
Сообщение: Re: How to successfully create a new function?
Следующее
От: Len
Дата:
Сообщение: Re: How to successfully create a new function?