On Tue, Oct 27, 2009 at 5:11 PM, fox7 <ale_shark7(at)yahoo(dot)it> wrote:
>
> Hi,
> I'm a new user...
> First of all excuse me for the bad english... :confused:
> I have a great problem!
> I have to do some little query with views, but the views contain thousand
> and thousand of records.
> Searching online I have found somthing about view index, but I don't know
> the right syntax for PostgreSQL.
> I have tries this:
> CREATE INDEX View1_index
> ON View1
> USING btree
> (term1);
Views do not help or hurt performance. Views encapsulate complex queries.
If you have a slow running query, the usual way to get help is to post:
*) explain analyze results (most important)
*) the query (important)
*) interesting tables/indexes (somewhat important)
merlin