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
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
View this message in context: http://www.nabble.com/Slow-running-query-with-views...how-to-increase-efficiency--with-index--tp26086104p26086104.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
pgsql-general by date
|Next:||From: Rhys A.D. Stewart||Date: 2009-10-27 22:37:10|
|Subject: Re: how to identify outliers|
|Previous:||From: Rhys A.D. Stewart||Date: 2009-10-27 21:36:12|
|Subject: how to identify outliers|