Oracle Database - What are the benefits to define a dimension in Oracle ?


Dimensions do not have to be defined.

However, if your application uses dimensional modeling, it is worth spending time creating them as it can yield significant benefits, because :

They are only mandatory if you use the Oracle Database - SQL Access Advisor (Summary Advisor) (a GUI tool for materialized view and index management) without a workload to recommend which materialized views and indexes to create, drop, or retain.

Powered by ComboStrap