Every session logs on to Teradata RDBMS with a certain priority, which then is inherited by all transactions originating from that session. This priority dictates how much CPU resource and processing time can be allocated to each query, thus effectively controlling query completion time.

Prioritization is active in all Teradata systems at all times. Teradata RDBMS itself automatically moves internal jobs into different priority levels, especially when a quick boost to one activity is critical to overall throughput.

Priority Scheduler is a resource management facility that controls system resource allocations based on a blueprint that you construct to satisfy your site-specific requirements.

With Priority Scheduler, you can define a prioritized system scheduling strategy that allows you to:

• Balance resource usage by groups of sessions and utilities

• Authorize users for access to prioritized levels of service based on the priority information carried in the user account string

• Dynamically alter the priority of a user or (with profiles) user group