| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | harding(dot)ian(at)gmail(dot)com |
| Cc: | General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Index Usage in View with Aggregates |
| Date: | 2009-09-17 16:07:55 |
| Message-ID: | dcc563d10909170907y434cd7d6r5f9745963468155a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Sep 17, 2009 at 9:55 AM, Ian Harding <harding(dot)ian(at)gmail(dot)com> wrote:
> 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.
You're far more likely to get a good answer on an oracle forum
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul M Foster | 2009-09-17 16:10:46 | Re: What kind of JOIN, if any? |
| Previous Message | Nathaniel | 2009-09-17 16:04:41 | COPY binary |