0 - 4 of 4 tags for querybanding
Querybanding and Changing Workload

I have a scheduled job(a set of CPU intensive statements) which should run under a high priority workload during off business hours and should run under a low prioirity workload when the sytem is busy during business hours.

By Kishore_1, 12 May 2014 | Tagged: querybanding workload management | 1 comment
Query Band tab in the Query Monitor

Is there anyway to alter how Viewpoint displays the queryband in the queryband tab in Query Monitor?  Prior to upgrading to VP 14.0, we were able to see the full queryband, but now it gets chopped off and I can't see the information that I'm looking for, I've attached a picture of what I'm talking about:

http://i.imgur.com/UYSUW.png

 

By TGooch44, 06 Feb 2012 | Tagged: viewpoint querybanding | 6 comments
Query Banding

What is QUERY_BAND and why we use it?

How does 'SET QUERY_BAND' command work in teradata utility?

 

By pareshgupta, 25 Jan 2012 | Tagged: queryband querybanding | 1 comment
Global and session level parameters in SQL

The commonly known technique to pass parameters to SQL statements at the system or session level utilizes tables (permanent or global temporary tables).
In this blog post, I'll show better performing techniques for system and user level variables using views and QueryBanding.
These solutions are based on TD13, but can also be used pre-TD13, although performance might be worse.

By dnoeth, 14 Mar 2011 | Tagged: views scalar subqueries parameters variables querybanding | 44 comments