QUERY PLAN FOR STATEMENT 1 (at line 1). STEP 1 The type of query is SET OPTION ON. QUERY PLAN FOR STATEMENT 1 (at line 1). Auxiliary scan descriptors required: 6 STEP 1 The type of query is SELECT. 37 operator(s) under root |ROOT:EMIT Operator | | |SORT Operator | | Using Worktable18 for internal storage. | | | | |HASH UNION Operator has 2 children. | | | Using Worktable17 for internal storage. | | | Key Count: 11 | | | | | | |HASH VECTOR AGGREGATE Operator | | | | GROUP BY | | | | Evaluate Grouped COUNT AGGREGATE. | | | | Using Worktable8 for internal storage. | | | | Key Count: 9 | | | | | | | | |N-ARY NESTED LOOP JOIN Operator has 3 children. | | | | | | | | | | |MERGE JOIN Operator (Join Type: Inner Join) | | | | | | Using Worktable7 for internal storage. | | | | | | Key Count: 1 | | | | | | Key Ordering: ASC | | | | | | | | | | | | |SORT Operator | | | | | | | Using Worktable6 for internal storage. | | | | | | | | | | | | | | |MERGE JOIN Operator (Join Type: Inner Join) | | | | | | | | Using Worktable5 for internal storage. | | | | | | | | Key Count: 1 | | | | | | | | Key Ordering: ASC | | | | | | | | | | | | | | | | |SORT Operator | | | | | | | | | Using Worktable4 for internal storage. | | | | | | | | | | | | | | | | | | |MERGE JOIN Operator (Join Type: Inner Join) | | | | | | | | | | Using Worktable3 for internal storage. | | | | | | | | | | Key Count: 1 | | | | | | | | | | Key Ordering: ASC | | | | | | | | | | | | | | | | | | | | |SORT Operator | | | | | | | | | | | Using Worktable2 for internal storage. | | | | | | | | | | | | | | | | | | | | | | |MERGE JOIN Operator (Join Type: Inner Join) | | | | | | | | | | | | Using Worktable1 for internal storage. | | | | | | | | | | | | Key Count: 1 | | | | | | | | | | | | Key Ordering: ASC | | | | | | | | | | | | | | | | | | | | | | | | |SCAN Operator | | | | | | | | | | | | | FROM TABLE | | | | | | | | | | | | | DM_INST | | | | | | | | | | | | | i | | | | | | | | | | | | | Using Clustered Index. | | | | | | | | | | | | | Index : PK_DM_INST | | | | | | | | | | | | | Forward Scan. | | | | | | | | | | | | | Positioning at index start. | | | | | | | | | | | | | Using I/O Size 16 Kbytes for index leaf pages. | | | | | | | | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | | | | | | | | Using I/O Size 16 Kbytes for data pages. | | | | | | | | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | | | | | | | | | | | | | | | |SCAN Operator | | | | | | | | | | | | | FROM TABLE | | | | | | | | | | | | | DR_EXPLOITANT | | | | | | | | | | | | | e | | | | | | | | | | | | | Index : SUN_ASS1_INS_FK | | | | | | | | | | | | | Forward Scan. | | | | | | | | | | | | | Positioning at index start. | | | | | | | | | | | | | Using I/O Size 16 Kbytes for index leaf pages. | | | | | | | | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | | | | | | | | Using I/O Size 16 Kbytes for data pages. | | | | | | | | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | | | | | | | | | | | |SCAN Operator | | | | | | | | | | | FROM TABLE | | | | | | | | | | | DR_UC | | | | | | | | | | | u | | | | | | | | | | | Using Clustered Index. | | | | | | | | | | | Index : PK_DR_UC | | | | | | | | | | | Forward Scan. | | | | | | | | | | | Positioning at index start. | | | | | | | | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | | | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | | | | | | Using I/O Size 16 Kbytes for data pages. | | | | | | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | | | | | | | |SCAN Operator | | | | | | | | | FROM TABLE | | | | | | | | | DM_ETAB | | | | | | | | | b | | | | | | | | | Using Clustered Index. | | | | | | | | | Index : PK_DM_ETAB | | | | | | | | | Forward Scan. | | | | | | | | | Positioning at index start. | | | | | | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | | | | Using I/O Size 16 Kbytes for data pages. | | | | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | | | |SCAN Operator | | | | | | | FROM TABLE | | | | | | | DM_ENTREP | | | | | | | p | | | | | | | Using Clustered Index. | | | | | | | Index : PK_DM_ENTREP | | | | | | | Forward Scan. | | | | | | | Positioning at index start. | | | | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | | Using I/O Size 16 Kbytes for data pages. | | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | |RESTRICT Operator | | | | | | | | | | | | |SCAN Operator | | | | | | | FROM TABLE | | | | | | | DM_DECLARATION | | | | | | | d | | | | | | | Index : DEC_ASS1_UCO_FK | | | | | | | Forward Scan. | | | | | | | Positioning by key. | | | | | | | Keys are: | | | | | | | UCO_S_CODEUC ASC | | | | | | | Using I/O Size 16 Kbytes for index leaf pages. | | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | | Using I/O Size 16 Kbytes for data pages. | | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | |SCAN Operator | | | | | | FROM TABLE | | | | | | dm_annexe_dec | | | | | | a | | | | | | Index : DEC_ASS1_LID_FK | | | | | | Forward Scan. | | | | | | Positioning by key. | | | | | | Keys are: | | | | | | DEC_L_ID ASC | | | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | Using I/O Size 2 Kbytes for data pages. | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | |HASH VECTOR AGGREGATE Operator | | | | GROUP BY | | | | Evaluate Grouped COUNT AGGREGATE. | | | | Using Worktable16 for internal storage. | | | | Key Count: 9 | | | | | | | | |N-ARY NESTED LOOP JOIN Operator has 5 children. | | | | | | | | | | |MERGE JOIN Operator (Join Type: Inner Join) | | | | | | Using Worktable15 for internal storage. | | | | | | Key Count: 1 | | | | | | Key Ordering: ASC | | | | | | | | | | | | |SORT Operator | | | | | | | Using Worktable14 for internal storage. | | | | | | | | | | | | | | |MERGE JOIN Operator (Join Type: Inner Join) | | | | | | | | Using Worktable13 for internal storage. | | | | | | | | Key Count: 1 | | | | | | | | Key Ordering: ASC | | | | | | | | | | | | | | | | |SORT Operator | | | | | | | | | Using Worktable12 for internal storage. | | | | | | | | | | | | | | | | | | |MERGE JOIN Operator (Join Type: Inner Join) | | | | | | | | | | Using Worktable11 for internal storage. | | | | | | | | | | Key Count: 1 | | | | | | | | | | Key Ordering: ASC | | | | | | | | | | | | | | | | | | | | |SORT Operator | | | | | | | | | | | Using Worktable10 for internal storage. | | | | | | | | | | | | | | | | | | | | | | |MERGE JOIN Operator (Join Type: Inner Join) | | | | | | | | | | | | Using Worktable9 for internal storage. | | | | | | | | | | | | Key Count: 1 | | | | | | | | | | | | Key Ordering: ASC | | | | | | | | | | | | | | | | | | | | | | | | |SCAN Operator | | | | | | | | | | | | | FROM TABLE | | | | | | | | | | | | | DR_UC | | | | | | | | | | | | | u | | | | | | | | | | | | | Using Clustered Index. | | | | | | | | | | | | | Index : PK_DR_UC | | | | | | | | | | | | | Forward Scan. | | | | | | | | | | | | | Positioning at index start. | | | | | | | | | | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | | | | | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | | | | | | | | Using I/O Size 16 Kbytes for data pages. | | | | | | | | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | | | | | | | | | | | | | | | |SCAN Operator | | | | | | | | | | | | | FROM TABLE | | | | | | | | | | | | | DR_EXPLOITANT | | | | | | | | | | | | | e | | | | | | | | | | | | | Index : UCO_ASS1_SUN_FK | | | | | | | | | | | | | Forward Scan. | | | | | | | | | | | | | Positioning at index start. | | | | | | | | | | | | | Using I/O Size 16 Kbytes for index leaf pages. | | | | | | | | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | | | | | | | | Using I/O Size 16 Kbytes for data pages. | | | | | | | | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | | | | | | | | | | | |SCAN Operator | | | | | | | | | | | FROM TABLE | | | | | | | | | | | DM_INST | | | | | | | | | | | i | | | | | | | | | | | Using Clustered Index. | | | | | | | | | | | Index : PK_DM_INST | | | | | | | | | | | Forward Scan. | | | | | | | | | | | Positioning at index start. | | | | | | | | | | | Using I/O Size 16 Kbytes for index leaf pages. | | | | | | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | | | | | | Using I/O Size 16 Kbytes for data pages. | | | | | | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | | | | | | | |SCAN Operator | | | | | | | | | FROM TABLE | | | | | | | | | DM_ETAB | | | | | | | | | b | | | | | | | | | Using Clustered Index. | | | | | | | | | Index : PK_DM_ETAB | | | | | | | | | Forward Scan. | | | | | | | | | Positioning at index start. | | | | | | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | | | | Using I/O Size 16 Kbytes for data pages. | | | | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | | | |SCAN Operator | | | | | | | FROM TABLE | | | | | | | DM_ENTREP | | | | | | | p | | | | | | | Using Clustered Index. | | | | | | | Index : PK_DM_ENTREP | | | | | | | Forward Scan. | | | | | | | Positioning at index start. | | | | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | | Using I/O Size 16 Kbytes for data pages. | | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | |SCAN Operator | | | | | | FROM TABLE | | | | | | DM_STOCK | | | | | | s | | | | | | Index : STK_ASS1_SUN_FK | | | | | | Forward Scan. | | | | | | Positioning by key. | | | | | | Keys are: | | | | | | EXP_L_ID ASC | | | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | Using I/O Size 2 Kbytes for data pages. | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | |SCAN Operator | | | | | | FROM TABLE | | | | | | DM_VARIATION_STK | | | | | | v | | | | | | Index : STK_ASS1_VST_FK | | | | | | Forward Scan. | | | | | | Positioning by key. | | | | | | Keys are: | | | | | | STK_L_IDSTK ASC | | | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | Using I/O Size 2 Kbytes for data pages. | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | |SCAN Operator | | | | | | FROM TABLE | | | | | | dm_annexe_dec | | | | | | a | | | | | | Using Clustered Index. | | | | | | Index : PK_DM_ANNEXE_DEC | | | | | | Forward Scan. | | | | | | Positioning by key. | | | | | | Keys are: | | | | | | LID_L_ID ASC | | | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | Using I/O Size 2 Kbytes for data pages. | | | | | | With LRU Buffer Replacement Strategy for data pages. | | | | | | | | | | |SCAN Operator | | | | | | FROM TABLE | | | | | | dm_declaration | | | | | | d | | | | | | Using Clustered Index. | | | | | | Index : PK_DM_DECLARATION | | | | | | Forward Scan. | | | | | | Positioning by key. | | | | | | Index contains all needed columns. Base table will not be read. | | | | | | Keys are: | | | | | | DEC_L_ID ASC | | | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | | | With LRU Buffer Replacement Strategy for index leaf pages.