Key Range Table Partitioning
With the functionality of key range table partitioning, the data in a database can be partitioned based upon the value of a given key, which significantly improves the performance of queries that require a full table scan. For more information, see the SQL Reference Guide.