phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From William <>
Subject Re:Re: Why index table inherits SALT_BUCKETs from data table?
Date Wed, 02 Nov 2016 06:20:23 GMT
Hi James,
  I tried, it acts exactly as what you said. 
  Thanks very much.


At 2016-11-02 12:54:26, "James Taylor" <> wrote:
>Hi William,
>By default, an index will have the same number of salt buckets as the data
>table, but you can override that by setting SALT_BUCKETS on the CREATE
>INDEX statement. If you set SALT_BUCKETS=0 on the statement, then the index
>won't be salted at all.
>On Tue, Nov 1, 2016 at 9:40 PM, William <> wrote:
>> Hi all
>>    If a data table is created with salt buckets, then all its index tables
>> are created with salt buckets too, no matter whether SALT_BUCKETS is
>> explicitly set or not in the DDL of index tables.
>>    Why are we doing this?
>>    I think that the selectivity of the indexed columns have nothing to do
>> with the selectivity of the PK columns of data table. I think it will be
>> better if users can decide whether to use salt buckets for index tables.
>>   Does someone have any idea of this behavior?
>> Thanks
>> William.
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message