phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <>
Subject Re: Why index table inherits SALT_BUCKETs from data table?
Date Wed, 02 Nov 2016 04:54:26 GMT
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