Data Block Selectivity | Teradata Vantage - Data Block Selectivity - Teradata Workload Management - Database Engine 20

Workload Management User Guide - 20.00

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Workload Management
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2025-11-20
dita:mapPath
gew1747088853217.ditamap
dita:ditavalPath
jlp1749501702948.ditaval
dita:id
icm1467243640567
Product Category
Teradata Vantage

Use the data block selectivity criterion (the percentage of the table the request accesses) to give more resources to requests that access a small subset of the table. For example, you can send a request doing a full-table scan against a large table to a low-priority workload, and send a request accessing only one partition (1/200th of the table) to a high-priority workload.

Data block selectivity is particularly useful on large partitioned tables, but it is also useful for nonpartitioned tables.