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. Thanks, James
On Tue, Nov 1, 2016 at 9:40 PM, William <[email protected]> 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.
