How to control DB table statistics gathering ?

[Klaster]

Hello All,

We are experience issues when WKFXXXXX tables are joined with others. The reason is that optimizer has inaccurate statistics using default settings and chooses wrong join order. In we calculate statistics manually (kill DB process), recalculate statistics using database tools and rerun - everything is fine and much faster. 

Of course best will be to change settings from default on task level - but if we get improvements in overall performance then site wide settings will be helpful

Thanks in advance

[Jonathon_wodnicki · Accepted solution]

Hi,

You can control join order by breaking up joins and doing them one at a time with enrichments.

I've done this in Postgres to reduce query time from 30+ seconds to sub-second.

Thanks,

-Jon