Optimal Performance Through The Correct Use Of The Teradata Partitioned Primary Index

Introduction Even though solid-state disks (SSDs) are increasingly replacing hard disks, access to mass storage will always be the slowest process in a database system. Therefore, all database providers search for methods to reduce the number of I/Os. As of Release 14.10, Teradata provides functions for reducing I/Os, such as column storage, block-level compression, or … Continue reading Optimal Performance Through The Correct Use Of The Teradata Partitioned Primary Index