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.


  <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: 28 Jun 2020