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
On Thu, Sep 17, 2009 at 9:55 AM, Ian Harding harding@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.
Hi all,
Is it possible to create an index on a view?
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: [EMAIL PROTECTED]
web: www.askesis.nl
---(end of broadcast)---
No, you can only create an index on the underlying tables. A view is a
virtual realtion, not a physical one, so what would the index point to?
Any functionality you need you should be able to get with functional
indexes.
Perhaps if/when postgresql gets materialized views an index on a view
On Wed, Jan 05, 2005 at 08:15:28PM +0100, Joost Kraaijeveld wrote:
Is it possible to create an index on a view?
Querying a view should use indexes if the underlying tables have
indexes and the planner can figure out how to use them. For complex
queries you might need to use a materialized
On Wed, 2005-01-05 at 13:14 -0700, Michael Fuhr wrote:
On Wed, Jan 05, 2005 at 08:15:28PM +0100, Joost Kraaijeveld wrote:
[snip]
PostgreSQL
doesn't have materialized views per se but it does have functionality
that can implement them.
Can you tell me what you mean by that?
Regards,
Jeff Davis wrote:
On Wed, 2005-01-05 at 13:14 -0700, Michael Fuhr wrote:
On Wed, Jan 05, 2005 at 08:15:28PM +0100, Joost Kraaijeveld wrote:
[snip]
PostgreSQL
doesn't have materialized views per se but it does have functionality
that can implement them.
Can you tell me what you mean by that?
You
On Wed, 2005-01-05 at 13:03 -0800, Jeff Davis wrote:
On Wed, 2005-01-05 at 13:14 -0700, Michael Fuhr wrote:
On Wed, Jan 05, 2005 at 08:15:28PM +0100, Joost Kraaijeveld wrote:
[snip]
PostgreSQL
doesn't have materialized views per se but it does have functionality
that can implement
Ragnar Hafstað wrote:
On Wed, 2005-01-05 at 13:03 -0800, Jeff Davis wrote:
On Wed, 2005-01-05 at 13:14 -0700, Michael Fuhr wrote:
On Wed, Jan 05, 2005 at 08:15:28PM +0100, Joost Kraaijeveld wrote:
[snip]
PostgreSQL
doesn't have materialized views per se but it does have