O'Reilly logo

Tera-Tom on Teradata Physical Implementation V12-V13 by Tera-Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9 – The Physical Data Model

“Nothing can stand against persistence; even a mountain will be worn down over time.”

We have arrived at the moment of truth. We are arriving at the top of the mountain. It is now time to create the Physical Database Design model. This chapter will cover the keys to an excellent Teradata Physical Data Model. Let this chapter be your guide and the data warehouse will not be overwhelmed by user queries. The steps below will empower your user to levels and new heights of greatness. The biggest keys to a good physical model are choosing the correct:

 

 

  • Primary Indexes

     

  • Secondary Indexes

     

  • Denormalization Tables

     

  • Derived Data Options

     

 

An Overview of picking the right Primary Index

“Only the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required