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.