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/