Re: Odd behavior with indices

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Fri, Feb 26, 2016 at 1:38 PM, joe meiring <josephmeiring@xxxxxxxxx> wrote:

Here's the distribution of parameter_id's

select count(parameter_id), parameter_id from datavalue group by parameter_id

88169   14
2889171 8
15805   17
8570    12
4257262 21
3947049 15
1225902 2
4091090 3
103877  10
633764  11
994442  18
49232   20
14935   4
563638  13
2955919 7

​Ok...again its beyond my present experience ​but its what the planner thinks about the distribution, and not what actually is present, that matters.

David J.