Refine your search by using the following advanced search options.

Criteria	Usage
Questions with keyword1 or keyword2	keyword1 keyword2
Questions with a mandatory word, e.g. keyword2	keyword1 +keyword2
Questions excluding a word, e.g. keyword2	keyword1 -keyword2
Questions with keyword(s) and a specific tag	keyword1 [tag1]
Questions with keyword(s) and either of two or more specific tags	keyword1 [tag1] [tag2]
To search for all posts by a user or all posts with a specific tag, start typing and choose from the suggestion list. Do not use a plus or minus sign with a tag, e.g., +[tag1].

How to reduce sample scan processes?

Question by slawomir.dabala (1) | Jul 25, 2018 at 06:28 AM nzpda

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)

0 Share