Index Usage in View with Aggregates

From: Ian Harding <harding(dot)ian(at)gmail(dot)com>
To: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Index Usage in View with Aggregates
Date: 2009-09-17 15:55:14
Message-ID: 725602300909170855p33aee550q972a10b21899aac6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nathaniel 2009-09-17 16:04:41 COPY binary
Previous Message Paul M Foster 2009-09-17 15:39:44 Re: What kind of JOIN, if any?