Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 09 Nov 2001 @ 20:55:26 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020