Archives of the TeradataForum
Message Posted: Thu, 05 Jul 2007 @ 20:55:54 GMT
For those using Sparse Join Indices, what have U found to be effective in the following scenarios:
(In each case assume, a table w/ more than 100M rows.)
1) One value appears on over 70% of the rows, no other value appears on more than 3% of the rows
2) Most frequent value on 40% of the rows, 2 other values on 10% of the rows
3) The top seven values range from 5 to 25% of the rows; together, the Top 7 account for 70% of the rows.
4) Top 2 values hit 20% of the rows each; the balance of the histogram is flat and completely made up by 10K other values
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|