How to reduce sample scan processes?
Answer by slawomir.dabala (1) | Jul 25, 2018 at 06:29 AM
Check the following params:
// Default settings ... as to when these options kick on
set JIT_STATS_MIN_ROWS = 5000000; -- 5 Million
set JIT_DISP_MIN_ROWS = 5e+08; -- 500 Million JIT_SAMPLE_GROWTH_POWER variable... which is 0.4 by default (about 40% of data)