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 view. PostgreSQL doesn't have materialized views per se but it does have functionality that can implement them. What problem are you trying to solve? Can you give us an example of what you're trying to do? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html