Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Jun 2001 @ 18:28:13 GMT


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


Subj:   Re: TeraData's optimizer
 
From:   Ruth Fenwick

The index I have on my date column is not ORDERED BY Values. If I change the index to by ORDERED BY Values, the optimizer will access the table via the index.

So, what's everyone's opinion/experience with ORDERED BY indexes? Pros/Cons

BTW, If I join to the calendar table AND change the constraint to be against the calendar table not the FACT table, it will use the NUSI on my FACT table.

Ruth



     
  <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