Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 15 Jan 2002 @ 16:32:21 GMT


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


Subj:   Re: SQL Tuning - Spool Space Problem
 
From:   Paul Johnson

I'd advise the addition of 'NOT NULL' to the index columns in each of the table create statements.

This is designed to give the optimiser less work to do as it doesn't have to worry about the potential for nulls. It also precludes skewing on nulls.

Paul Johnson.



     
  <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: 27 Dec 2016