Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Canary Queries and TDWM
 
From:   Diehl, Robert

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023