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

> Database > Oracle Database

Table of Contents

1 - About

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.

Advertising
db/oracle/why_i_must_create_dimension_in_oracle.txt · Last modified: 2017/09/06 19:29 by gerardnico