How to control DB table statistics gathering ?

Avatar

Avatar

Klaster

Avatar

Klaster

Klaster

19-06-2020

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

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

19-06-2020

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

Answers (0)