Tuning a data warehouse (dw) requires dealing with a thick stack of layers. To name a few:
- Relational database management system (RDBMS) server hardware
- RDBMS server operating system (e.g. AIX, Solaris, Windows, Linux)
- RDBMS (e.g. Oracle, DB2, Teradata)
- Database schema (tables/views/indexes)
- Network
- Application server hardware
- Application server software
- Application server operating system
In this blog, I will focus on the database schema layer