Skip to main content
Level 3
Dec 27, 2021 4:43 PM UTC
Solved

RDBMS statistics update

Hello,

 

In the database cleanup workflow, when XtkCleanup_NoStats is set to 0, it does a "RDBMS statistics update".

What does it mean exactly? Is it some kind of vaccum? I am running ACC on a Oracle DB. So no vaccum functionnality.

Any idea?

 

Thank you,

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Milan_Vucetic
Milan_VuceticAccepted solution
Level 9
Dec 29, 2021 6:35 AM UTC

Hi @roro_coeur,


Statistics simply are a form of dynamic metadata that assists the query optimizer in making better decisions. For example, if there are only a dozen rows in a table, then there's no point going to an index to do a lookup; you will always be better off doing a full table scan. But if that same table grows to a million rows, then you will probably be better off using the index.
It is important to remember that statistics are only helpful if they are kept up to date. This can be done with automatic updating statistics or a regularly scheduled (nightly/weekly) update statistics command. Also, index rebuilds will automatically perform a statistics update.

 

Regards,
Milan

5 replies

Milan_Vucetic
Milan_VuceticAccepted solution
Level 9
Dec 29, 2021 6:35 AM UTC

Hi @roro_coeur,


Statistics simply are a form of dynamic metadata that assists the query optimizer in making better decisions. For example, if there are only a dozen rows in a table, then there's no point going to an index to do a lookup; you will always be better off doing a full table scan. But if that same table grows to a million rows, then you will probably be better off using the index.
It is important to remember that statistics are only helpful if they are kept up to date. This can be done with automatic updating statistics or a regularly scheduled (nightly/weekly) update statistics command. Also, index rebuilds will automatically perform a statistics update.

 

Regards,
Milan

Translate
Level 3
Dec 29, 2021 10:23 AM UTC

Thank you Milan!

Translate