![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Fri, 06 Jul 2007 @ 11:16:50 GMT
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.
Regards,
Victor
| |