Hi James, I tried, it acts exactly as what you said. Thanks very much.
William. At 2016-11-02 12:54:26, "James Taylor" <[email protected]> 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. >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.
