Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 06 Jul 2007 @ 11:16:50 GMT

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

Subj:   Re: Break Point for using a Sparse Join Index
From:   Victor Sokovin

  Feel free to add other scenarios or considerations to the items above.  

  I'm looking for experiences/thoughts regarding SpJI, but approaches > using alternative indexing strategies are welcome.  

Bill, you listed a few tables on which potentially useful sparse joins could be defined but you did not tell us anything about the most frequent queries your users and/or applications run on those tables. Queries may or may not use JIs, so at the end of the day their usefulness will only be confirmed by specific tests on your own site.



  <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: 15 Jun 2023