Re: [PERFORM] Query plan for views and WHERE clauses, Luke is not using the index

Thanks a lot for your detailed explanation. I will try ASAP with no DISTINCT ( we are quite sure it is not needed anyway ), and report back here. Michaël 2017-08-21 23:52 GMT+02:00 David Rowley : > On 19 August 2017 at 04:46, kimaidou wrote: > > When we call the WHERE on

Re: [PERFORM] Query plan for views and WHERE clauses, Luke is not using the index

raw query and the view with WHERE ? Regards Michaël 2017-08-18 18:46 GMT+02:00 kimaidou : > Hi all, > > I have come across a unexpected behavior. > You can see full detail on an issue on the QGEP project in Github : > https://github.com/QGEP/QGEP/issues/308#issuecomment-323122514 &g

[PERFORM] Query plan for views and WHERE clauses, Luke is not using the index

Hi all, I have come across a unexpected behavior. You can see full detail on an issue on the QGEP project in Github : https://github.com/QGEP/QGEP/issues/308#issuecomment-323122514 Basically, we have this view with some LEFT JOIN : http://paste.debian.net/982003/ We have indexes on some fields (