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 6 – Partitioned Tables

“The entire sum of existence is the magic of being needed by just one other person.”

– Vi Putnam

 

The next page shows a table that will be used to show how Teradata Partitioning works. We will take this table and show it in a Non-Partitioned fashion and then Partition the table and show how Teradata runs certain queries faster.

All I want you to notice right now is the column Order_Date. Notice that we have dates in both January and February.

text

Range Queries

“Cowards die many times before their deaths; the valiant never taste of death but once.”

– William Shakespeare

 

The next page shows our Order_Table ...

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