A complex task

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