help to improve query, query rewrite, and optimizer performance.
We will attempt to demonstrate all of the factors in this list later on in
this chapter.
Note:
When building dimensional hierarchies with dimension objects,
always attempt to build hierarchical structures from a business require-
ments perspective. Business people need to use the data in your data ware-
house. Programmers and database administrators only build data
warehouses; they do not actually use the data to retrieve real-world applica-
ble results.
Let’s take a brief look at the negative ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.