Thread: Index Usage in View with Aggregates

Index Usage in View with Aggregates

From
Ian Harding
Date:
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

Re: Index Usage in View with Aggregates

From
Scott Marlowe
Date:
On Thu, Sep 17, 2009 at 9:55 AM, Ian Harding <harding.ian@gmail.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