Archives of the TeradataForum
Message Posted: Fri, 01 Aug 2008 @ 21:48:50 GMT
To get canary queries to run in the proper workload they must meet all the classification criteria of the workload.
You also have to make sure the query does not meet the classification criteria that is higher in the evaluation order.
In our case we had to do two things.
1) use different ids for the canary queries. You don't necessarily have to do this one as long as the id you are using does not automatically fall into a workload in the evaluation order which was our case.
2) Male sure plan estimates fell into the workload we wanted the canary query to run.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|