The finest granularity we have available is to specify a guidepost width at the table level with the GUIDEPOSTS_WIDTH=## property. This will take effect for that table next time stats are collected (on a major compaction or when collected manually through the UPDATE STATISTICS command).
On Tue, Aug 29, 2017 at 7:23 AM 孙文隆 <wenl...@icloud.com> wrote: > Hi there, > > I am optimizing an sql that is compiled to point lookups. Since sometimes > there could be many thousands of "in" conditions in the sql, I would like > to increase the parallelism number for better performance. I know that I > can increase the salted bucket number or decrease the guide post width to > increase the parallelism number. But is there any way to specify the > parallelism at the runtime of JDBC so that I can change it according to the > number of "in" conditions? > > > Best regards, > Ryan
