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.
Solved! Go to Solution.