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).
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?