Re: View not using index

Thanks for the reply, Brice.


Brice André wrote
>    - If your test DB has so few data that it is not efficient to use the
>    index, this last will not be used. You should probably try to insert
> more
>    data before performing the test
>    - the query planner uses table statistics to decide if it uses an
> index.
>    But, if those statistics are not up-to-date, the choice can be not
> optimal.
>    You should maybe try to look at 'Analyse' command to get more info :

As I said, the data in my production env is populated but I'm getting the
same results, even after running ANALYZE on the tables.





--
View this message in context: http://postgresql.nabble.com/View-not-using-index-tp5865953p5866097.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.