Execution of query with "Dynamic sampling" hint

query_with_dynamic_sampling_hint.txt

SQL> SELECT /*+ dynamic_sampling(11) gather_plan_statistics  */
		   RECV_ACC_ID
	  FROM S_ACC_DOC B
	 WHERE     D.DOC_TYPE IN ('X11',
				  'X21',
				  'X71',
				  'X81')
	 AND D.DOC_REC_DATE >= TO_DATE ('01.01.2021', 'DD.MM.YYYY')
	 AND NVL (D.RELATED_DOC_ID, -1903) = -1903
	 AND NVL (D.RELATED_DOC, 'BJK') = 'BJK';
		   
        
SQL> select * from dbms_xplan.display_cursor('brgh4jm2xppfn',0,'+ALLSTATS LAST');
	 
SQL_ID  brgh4jm2xppfn, child number 0
-------------------------------------
SELECT /*+ dynamic_sampling(11) gather_plan_statistics  */      
RECV_ACC_ID    FROM S_ACC_DOC B   WHERE     D.DOC_TYPE IN 
('X11',           'X21',           'X71',           'X81')      AND 
D.DOC_REC_DATE >= TO_DATE ('01.01.2021', 'DD.MM.YYYY')      AND 
NVL (D.RELATED_DOC_ID, -1903) = -1903      AND NVL 
(D.RELATED_DOC, 'BJK') = 'BJK'
 
Plan hash value: 3313358201
 
---------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                            | Name                           | Starts | E-Rows | A-Rows |   A-Time   | Buffers |
---------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                     |                                |      1 |        |  85619 |00:00:00.13 |   89215 |
|   1 |  INLIST ITERATOR                     |                                |      1 |        |  85619 |00:00:00.13 |   89215 |
|   2 |   TABLE ACCESS BY INDEX ROWID BATCHED| T_ACC_DOC                      |      4 |  86000 |  85619 |00:00:00.13 |   89215 |
|*  3 |    INDEX RANGE SCAN                  | IN_ACCDOC_DCTYPRLTDDDTRLTD     |      4 |  85619 |  85619 |00:00:00.03 |    6082 |
---------------------------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   3 - access((("D"."DOC_TYPE"='X11' OR "D"."DOC_TYPE"='X21' OR "D"."DOC_TYPE"='X71' OR 
	"D"."DOC_TYPE"='X81')) AND "D"."SYS_NC00076$"=(-1903) AND "D"."DOC_REC_DATE">=TO_DATE(' 2021-01-01 00:00:00', 
	'syyyy-mm-dd hh24:mi:ss') AND "D"."SYS_NC00077$"='BJK')
	filter("D"."SYS_NC00077$"='BJK')
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=AUTO)
	 85619  rows processed