Adhoc Queries - How to handle them in the Teradata environment

Adhoc queries are always the difficult and resource-consuming processes. They are generally fired by the business users and will be used for Strategic decision making.

With the growing size of the Enterprise, this task is becoming more costly.

For the Teradata Database administrator, the following options are available:

1. Understand the Workload mix (Using Workload Monitor) and balance the Workload (Use Teradata    Active Workload Manager)
2. Increase or decrease the priority of the Query
3. Monitor the resource consumption of the Query - (using Viewpoint)
4. Give "Privileged Users" permissions to the Reporting Users

Administrators can see the following Teradata e-brochure

As for the  End-users, there are a lot of Ad-hoc query tools or Reporting tools.

These tools have a few drawbacks which you can read in the article listed below:
Ad Hoc Query Tools Shootout (This article was written in 1995 and till date some of the drawbacks mentioned by Dr. Paul Dorsey remain)