Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Share this Page URL

Chapter 6: Partitioned Tables > NEW! Character Based PPI Multi-Level Example - Pg. 197

Physical Implementation NEW! Character Based PPI Multi-Level Example ber, no matter where you go there you are." - Unknown And remember, no matter where you go, Teradata can track your state quickly because they have Character-Based Partition Primary Index (PPI). Our next example shows a Multi-Level partitioning example. The first partition is the Date Partition and inside each date is the State_Code partition. We then ask the query, Show me all claims that happened during the first eight days of January in the state of Ohio.