Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

RDBMS statistics update

Avatar

Level 3

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,

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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