Re: [GENERAL] INDEX ONLY scan with expression index

2016-03-07 Thread David G. Johnston
On Mon, Mar 7, 2016 at 11:33 PM, Tom Lane wrote: > James Sewell writes: > > Would anyone be able to shed some light on why expression based indexes > > can't be used for an index only scan? > > I've found a few comments saying this is the case, and I've proven it is > > the case in reality - but

Re: [GENERAL] INDEX ONLY scan with expression index

2016-03-07 Thread Tom Lane
James Sewell writes: > Would anyone be able to shed some light on why expression based indexes > can't be used for an index only scan? > I've found a few comments saying this is the case, and I've proven it is > the case in reality - but I can't seem to find the why. Well, it would help if you po

[GENERAL] INDEX ONLY scan with expression index

2016-03-07 Thread James Sewell
Hello, Would anyone be able to shed some light on why expression based indexes can't be used for an index only scan? I've found a few comments saying this is the case, and I've proven it is the case in reality - but I can't seem to find the why. Cheers, James Sewell, Solutions Architect __