 |
 |
Archives of the TeradataForum
Message Posted: Wed, 06 Jun 2001 @ 18:28:13 GMT
| 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
| |
