On Tuesday 27 October 2009, fox7 <ale_shark7(at)yahoo(dot)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."