[Info-ingres] stats on tables with more than 1million rows

[Martin Bowes]

Hi All,

It appears that optimizedb automatically switches to sampling once a table breaks 1million rows, which is cool.

But now I have a table with unique keys which the stats insist is a non-unique key with an average count per value of 1.6.

Is this a problem?

Martin Bowes

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20170127/36e2e0b8/attachment.html>