Incorrect fact at 5:49, the video and caption says 10,000 for 7-Completed, but looking back suggests it was 15,000 ?? and the plan actually shows 15271, so height balanced still appears to be working well, maybe picked a wrong value to illustrate ?
The mistake carries on at 6:25, 7-Completed fills 2 buckets, not 1.5. At 6:52, 2-Assigned is 10, not 3. Although I get the general gist regarding pitfalls of height balanced and hybrid :)
Correct. Filmed that a long time ago, but I remember needing to make corrections afterwards when I later gave that presentation live at a conference. I should have gone back and updated the video
Connor, thank you for your reply. In Christian Antognini's book, I read that "The maximum number of buckets is 254 up to version 11.2, and 2,048 as of version 12.1." So in versions 12+ we can set 'for all column size 2048' and get a better histogram?
@@mikhaill244 Yes, but I wouldnt do it globally...you could end up with a very large dictionary. For those special cases where 2048 will get you from hybrid to frequency, it might be useful
Thank you Connor
HI Connor, Can you please adjust you video window as its blocking query and query results.
Incorrect fact at 5:49, the video and caption says 10,000 for 7-Completed, but looking back suggests it was 15,000 ?? and the plan actually shows 15271, so height balanced still appears to be working well, maybe picked a wrong value to illustrate ?
The mistake carries on at 6:25, 7-Completed fills 2 buckets, not 1.5. At 6:52, 2-Assigned is 10, not 3.
Although I get the general gist regarding pitfalls of height balanced and hybrid :)
Correct. Filmed that a long time ago, but I remember needing to make corrections afterwards when I later gave that presentation live at a conference. I should have gone back and updated the video
Do I understand correctly, I need to always specify 'for all column size 255' and check that there are no HEIGHT-BALANCED and HYBRID, right?
size 255 will end up with frequenct and top-frequence wherever possible. Anything else will be hybrid.
Connor, thank you for your reply. In Christian Antognini's book, I read that "The maximum
number of buckets is 254 up to version 11.2, and 2,048 as of version 12.1." So in versions 12+ we can set 'for all column size 2048' and get a better histogram?
@@mikhaill244 Yes, but I wouldnt do it globally...you could end up with a very large dictionary. For those special cases where 2048 will get you from hybrid to frequency, it might be useful