Re: [PERFORM] View based upon function won't use index on joins

This seems to result in the same problem; should I attempt to pull for a specific id_nbr/id_qfr, postgres uses the index without a problem. If I try to join the two tables/views however, it insists on doing a sequential scan (actually two in this case) and will not use the index. Any other

Re: [PERFORM] View based upon function won't use index on joins

.. 2009/11/20 Віталій Тимчишин tiv...@gmail.com 20 листопада 2009 р. 17:01 Jonathan Foy the...@gmail.com написав: This seems to result in the same problem; should I attempt to pull for a specific id_nbr/id_qfr, postgres uses the index without a problem. If I try to join the two tables/views

[PERFORM] View based upon function won't use index on joins

Hello, I've inherited some very...interestingly... designed tables, and am trying to figure out how to make them usable. I've got an ugly hack in place, but it will not use an index properly, and I'm hoping someone will be able to point me in the right direction. Production is running 8.1.3,