How to control DB table statistics gathering ? | Community
Skip to main content
K
Klaster
Level 2
June 19, 2020
Solved

How to control DB table statistics gathering ?

  • June 19, 2020
  • 1 reply
  • 1418 views

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

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

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
June 20, 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

Terms & ConditionsAccessibility statement

Loading footer...