 |
 |
Archives of the TeradataForum
Message Posted: Thu, 13 Dec 2001 @ 13:37:08 GMT
| Subj: | | Re: Performance optimization issue |
| |
| From: | | Geoffrey Rommel |
| | For an index on the date to be used the dates must be specified explicitly, that is not using between or > . | |
This is not quite true. If you define your secondary index with ORDER BY VALUES, Teradata will use the index for small ranges. I
have used this very technique on a large table with transaction dates, thus:
create index (transaction_date) order by values on table_name;
| |
