Filtering out badly written queries with WLM

Database
Enthusiast

Filtering out badly written queries with WLM

Hi, 

 

Is there a possible way to filter out on the workload manager all queries that do a SELECT on a certain view or table (given by me) without specifying an WHERE clause?

 

We have an huge fact table that sometimes users do not specify any WHERE clause and the query runs for many hours before we notice it. We would like to do not even start running these queries.


Accepted Solutions
Highlighted
Junior Contributor

Re: Filtering out badly written queries with WLM

You can add a filter based on the Request Target: either a Full Table Scan or Estimated percent of table blocks accessed during the query, for end users it should be for Only statements of the following type: Select

1 ACCEPTED SOLUTION
1 REPLY
Highlighted
Junior Contributor

Re: Filtering out badly written queries with WLM

You can add a filter based on the Request Target: either a Full Table Scan or Estimated percent of table blocks accessed during the query, for end users it should be for Only statements of the following type: Select