Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 22 Sep 2004 @ 16:54:14 GMT


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


Subj:   Re: Dropping a secondary index during an INS/SEL
 
From:   Ballinger, Carrie

You could increase the priority of the session running the insert/select, if you can tolerate a relative decrease in priority for the other active work. It should complete sooner as it will have faster access to resources.

You do this by changing the performance group name for the session either through Teradata Manager or PMON. If all your user-submitted work is running at the default priority of $M, you could move this session to performance group $H, for example. To give it even more support, you could change the assigned weight of the allocation group that $H points to, allocation group 3, from its default weight of 20 up to 35. Just make sure $R's allocation group (#4) has a slightly higher weight.


Thanks, --Carrie



     
  <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