Archives of the TeradataForum
Message Posted: Tue, 07 Nov 2006 @ 21:24:44 GMT
| Subj: || || Value Ordered NUSI & Regular NUSI on Same Column? |
| From: || || Stover, Terry |
We're experimenting adding value ordered nusi's to some of our frequently accessed date columns and most of these columns already have regular
nusi's defined. The goal is to speed up the queries using date ranges that are currently doing full table scans. I haven't found any guidance in
the various NCR manuals, does anyone have experience using both hash and value ordered nusi's on the same columns?.