Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 12 Sep 2003 @ 18:01:46 GMT


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


Subj:   Re: Will an Index be used with Derived Tables
 
From:   Dieter Noeth

Walter, Todd A wrote:

  Sorry Michael but this statement is not correct. The column order in the derived table is irrelevant (unlike the rule for CREATE TABLE where if no PI is specified TD defaults to the first column).  



Thanks for the clarification, Todd.

I heard that rumour several times and always answered similar. I just didn't want to be too rude, as i didn't write a book, yet ;-)


Dieter



     
  <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