Dynamic statistics on regular and aggregated records are expensive computations for the Oracle Commerce MDEX Engine.
You should only
enable a dimension for dynamic statistics if you intend to use the statistics
in your Oracle Commerce-enabled front-end application. Similarly, you should only use
the
--stat-abins
flag with the dgraph to calculate
aggregated record counts if you intend to use the statistics in your
Oracle Commerce-enabled front-end application. Because the dgraph does additional
computation for additional statistics, there is a performance cost for those
that you are not using.
In applications where record counts or aggregated record counts are not used, these lookups are unnecessary. The MDEX Engine takes more time to return navigation objects for which the number of dimension values per record is high.
Note that Dgidx performance is not affected by dimension value statistics.