- 
	
	
		
			
			
				Junior Member
			
			
			
			
				
					
						  
 
					    
				 
 
			
				
				
				
					Teradata Optimization and performance tuning
				
					
						
							Can any one give me live example for performance tuning in teradata?
 
 
 
 
 
 
 
 
 
- 
	
	
		
		
			
				
				
				
					Re: Teradata Optimization and performance tuning
				
					
						
							Please find related discussions here .
 
 
 
 
 
 
 
 
 
- 
	
	
		
			
			
				Junior Member
			
			
			
			
				
					
						  
 
					    
				 
 
			
				
				
				
					Re: Teradata Optimization and performance tuning
				
					
						
							When  u receive a performance issue,
 first go with the EXPLAIN statement
 so that u will get an idea where the problem is......
 
 The other step is skewing issue...
 just check whether the data distribution
 is even among the amps or not....
 
 u can also check with the primary indexes also
 
 
 
 
 
 
 
 
 
 
	
	
	
	
	
	
	
	
	
	
	
	
		
		
			
				 Posting Permissions
				Posting Permissions
			
			
				
	
		- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-  
Forum Rules