A poorly written query can return too much data, making the results unusable. These types of queries often produce meaningless results, are very resource-intensive, and reduce the performance of your system.
Using filters, you can protect your system from poorly written queries by preventing these queries from even starting to execute. Rejecting bad queries also helps educate the users to write better and more specific queries, which can reduce the number of bad queries over time.
For information about how to write good queries, refer to Teradata’s SQL documentation.
- Queries that return too many rows
- Queries that take too long to run
- Queries that scan very large tables
- Teradata Database version: 16.00
- Operating system: SLES 11
- System: PROD1
- Ruleset: BadQueries