Archives of the TeradataForum
Message Posted: Wed, 06 Jun 2001 @ 18:28:13 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|