Archives of the TeradataForum

Message Posted: Fri, 01 Aug 2008 @ 21:48:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Mark,

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.

Thanks,

Bob Diehl

	<Prev	Next>		<<First	<Prev	Next>	Last>>