Index Usage in View with Aggregates

Поиск
Список
Период
Сортировка
От Ian Harding
Тема Index Usage in View with Aggregates
Дата
Msg-id 725602300909170855p33aee550q972a10b21899aac6@mail.gmail.com
обсуждение исходный текст
Ответы Re: Index Usage in View with Aggregates  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
I have never had this particular problem in PostgreSQL, it seems to
"just know" when queries can be "flattened" and indexes used.  I know
that takes tons of work.  Thank you for that.

Here's the Oracle question.

http://stackoverflow.com/questions/1439500/oracle-index-usage-in-view-with-aggregates

I suspect I have made some subtle mistake in changing that SQL into a
view that is breaking Oracle's ability to know that an index can be
used.  Any and all advice is appreciated.

- Ian

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

Предыдущее
От: Paul M Foster
Дата:
Сообщение: Re: What kind of JOIN, if any?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Index Usage in View with Aggregates