Re: Dictionary encoding

2018-08-06 Thread Saeid Sattari
Hi Todd, Thank you for good descriptions :) Regards, Saeid On Mon, 6 Aug 2018, 21:26 Todd Lipcon, wrote: > Hi Saeid, > > It's not based on the number of distinct values, but rather on the > combined size of the values. I believe the default is 256kb, so assuming > your strings are pretty sho

Re: Dictionary encoding

2018-08-06 Thread Todd Lipcon
Hi Saeid, It's not based on the number of distinct values, but rather on the combined size of the values. I believe the default is 256kb, so assuming your strings are pretty short, a few thousand are likely to be able to be dict-encoded. Note that dictionaries are calculated per-rowset (small chun