Re: Slow running query with views...how to increase efficiency? with index?

On Tuesday 27 October 2009, fox7 <ale_shark7@yahoo.it> wrote:
> I have tries this:
> CREATE INDEX View1_index
>   ON View1
>   USING btree
>   (term1);
>
> It isn't correct because this syntax is for tables, instead View1 is a
> view. Do you know the syntax to create view index?
> thanks a lot

You can't create indexes on views. They will make use of appropriate indexes
on the underlying tables, however.

--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."