Teradata Data Access: Single-AMP vs. All-AMP Binary Search and Sequential Search
Teradata data access is categorized based on the number of AMPs involved and the technique employed to search rows within a data block. In our article about SQL Tuning, we mentioned that one of the main goals in performance optimization is to distribute the workload evenly across all AMPs. Using a single AMP is best …