Archives of the TeradataForum
Message Posted: Fri, 09 Nov 2001 @ 20:55:26 GMT
| Subj: || || Re: Data Model with Microstrategy as frontend tool |
| From: || || James Judge |
Some clarification here; the latest R4 indexing schemes allows non-PI (as in VOI and join-indexes on a single table (aka covered index))
to have a different hash key. This will allow joining on those indexes. Also, the use of NUSIs to select ROWids of primary rows and then
join to only those rows by the hask-key is an option for the Optimizer to choose.