Plan SELECT STATEMENT ALL_ROWSCost: 1.84467440737096E19 Bytes: 9,650,000,965 Cardinality: 10,000,001 389 TEMP TABLE TRANSFORMATION 17 LOAD AS SELECT SYS_TEMP_0FD9D690F_E7F3C8 16 HASH GROUP BY Cost: 132,670 Bytes: 547,895,556 Cardinality: 5,073,107 15 HASH JOIN RIGHT OUTER Cost: 8,963 Bytes: 547,895,556 Cardinality: 5,073,107 1 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 260,195 Cardinality: 52,039 14 HASH JOIN Cost: 7,458 Bytes: 312,605,927 Cardinality: 3,035,009 2 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_APPOINTMENT Cost: 106 Bytes: 698,500 Cardinality: 63,500 13 HASH JOIN RIGHT OUTER Cost: 7,343 Bytes: 207,863,420 Cardinality: 2,259,385 3 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 107,575 Cardinality: 21,515 12 HASH JOIN Cost: 7,231 Bytes: 196,566,495 Cardinality: 2,259,385 4 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 559,091 Cardinality: 43,007 11 HASH JOIN OUTER Cost: 6,911 Bytes: 167,196,858 Cardinality: 2,259,417 9 HASH JOIN Cost: 1,046 Bytes: 2,055,924 Cardinality: 29,796 5 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 946,044 Cardinality: 28,668 8 HASH JOIN Cost: 490 Bytes: 1,164,636 Cardinality: 32,351 6 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_APPOINTMENT_TYPE Cost: 3 Bytes: 15 Cardinality: 1 7 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 1,358,742 Cardinality: 64,702 10 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 34 LOAD AS SELECT SYS_TEMP_0FD9D6910_E7F3C8 33 HASH GROUP BY Cost: 129,798 Bytes: 532,676,235 Cardinality: 5,073,107 32 HASH JOIN RIGHT OUTER Cost: 8,963 Bytes: 532,676,235 Cardinality: 5,073,107 18 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 260,195 Cardinality: 52,039 31 HASH JOIN Cost: 7,458 Bytes: 303,500,900 Cardinality: 3,035,009 19 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_APPOINTMENT Cost: 106 Bytes: 508,000 Cardinality: 63,500 30 HASH JOIN RIGHT OUTER Cost: 7,343 Bytes: 207,863,420 Cardinality: 2,259,385 20 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 107,575 Cardinality: 21,515 29 HASH JOIN Cost: 7,231 Bytes: 196,566,495 Cardinality: 2,259,385 21 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 559,091 Cardinality: 43,007 28 HASH JOIN OUTER Cost: 6,911 Bytes: 167,196,858 Cardinality: 2,259,417 26 HASH JOIN Cost: 1,046 Bytes: 2,055,924 Cardinality: 29,796 22 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 946,044 Cardinality: 28,668 25 HASH JOIN Cost: 490 Bytes: 1,164,636 Cardinality: 32,351 23 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_APPOINTMENT_TYPE Cost: 3 Bytes: 15 Cardinality: 1 24 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 1,358,742 Cardinality: 64,702 27 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 51 LOAD AS SELECT SYS_TEMP_0FD9D6911_E7F3C8 50 HASH GROUP BY Cost: 132,670 Bytes: 547,895,556 Cardinality: 5,073,107 49 HASH JOIN RIGHT OUTER Cost: 8,963 Bytes: 547,895,556 Cardinality: 5,073,107 35 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 260,195 Cardinality: 52,039 48 HASH JOIN Cost: 7,458 Bytes: 312,605,927 Cardinality: 3,035,009 36 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_APPOINTMENT Cost: 106 Bytes: 698,500 Cardinality: 63,500 47 HASH JOIN RIGHT OUTER Cost: 7,343 Bytes: 207,863,420 Cardinality: 2,259,385 37 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 107,575 Cardinality: 21,515 46 HASH JOIN Cost: 7,231 Bytes: 196,566,495 Cardinality: 2,259,385 38 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 559,091 Cardinality: 43,007 45 HASH JOIN OUTER Cost: 6,911 Bytes: 167,196,858 Cardinality: 2,259,417 43 HASH JOIN Cost: 1,046 Bytes: 2,055,924 Cardinality: 29,796 39 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 946,044 Cardinality: 28,668 42 HASH JOIN Cost: 490 Bytes: 1,164,636 Cardinality: 32,351 40 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_APPOINTMENT_TYPE Cost: 3 Bytes: 15 Cardinality: 1 41 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 1,358,742 Cardinality: 64,702 44 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 68 LOAD AS SELECT SYS_TEMP_0FD9D6912_E7F3C8 67 HASH GROUP BY Cost: 129,798 Bytes: 532,676,235 Cardinality: 5,073,107 66 HASH JOIN RIGHT OUTER Cost: 8,963 Bytes: 532,676,235 Cardinality: 5,073,107 52 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 260,195 Cardinality: 52,039 65 HASH JOIN Cost: 7,458 Bytes: 303,500,900 Cardinality: 3,035,009 53 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_APPOINTMENT Cost: 106 Bytes: 508,000 Cardinality: 63,500 64 HASH JOIN RIGHT OUTER Cost: 7,343 Bytes: 207,863,420 Cardinality: 2,259,385 54 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 107,575 Cardinality: 21,515 63 HASH JOIN Cost: 7,231 Bytes: 196,566,495 Cardinality: 2,259,385 55 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 559,091 Cardinality: 43,007 62 HASH JOIN OUTER Cost: 6,911 Bytes: 167,196,858 Cardinality: 2,259,417 60 HASH JOIN Cost: 1,046 Bytes: 2,055,924 Cardinality: 29,796 56 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 946,044 Cardinality: 28,668 59 HASH JOIN Cost: 490 Bytes: 1,164,636 Cardinality: 32,351 57 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_APPOINTMENT_TYPE Cost: 3 Bytes: 15 Cardinality: 1 58 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 1,358,742 Cardinality: 64,702 61 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 152 LOAD AS SELECT SYS_TEMP_0FD9D6913_E7F3C8 151 VIEW ZZZZZZ_DM. Cost: 4,932,336,308 Bytes: 41,307,929,796,276 Cardinality: 1,588,766,530,626 150 WINDOW SORT PUSHED RANK Cost: 4,932,336,308 Bytes: 986,624,015,518,746 Cardinality: 1,588,766,530,626 149 HASH JOIN Cost: 6,838,097 Bytes: 986,624,015,518,746 Cardinality: 1,588,766,530,626 86 VIEW VIEW SYS.VW_NSO_12 Cost: 132,670 Bytes: 238,436,029 Cardinality: 5,073,107 85 SORT UNIQUE Cost: 132,670 Bytes: 547,895,556 Cardinality: 5,073,107 84 SORT GROUP BY Cost: 132,670 Bytes: 547,895,556 Cardinality: 5,073,107 83 HASH JOIN RIGHT OUTER Cost: 8,963 Bytes: 547,895,556 Cardinality: 5,073,107 69 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 260,195 Cardinality: 52,039 82 HASH JOIN Cost: 7,458 Bytes: 312,605,927 Cardinality: 3,035,009 70 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_APPOINTMENT Cost: 106 Bytes: 698,500 Cardinality: 63,500 81 HASH JOIN RIGHT OUTER Cost: 7,343 Bytes: 207,863,420 Cardinality: 2,259,385 71 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 107,575 Cardinality: 21,515 80 HASH JOIN Cost: 7,231 Bytes: 196,566,495 Cardinality: 2,259,385 72 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 559,091 Cardinality: 43,007 79 HASH JOIN OUTER Cost: 6,911 Bytes: 167,196,858 Cardinality: 2,259,417 77 HASH JOIN Cost: 1,046 Bytes: 2,055,924 Cardinality: 29,796 73 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 946,044 Cardinality: 28,668 76 HASH JOIN Cost: 490 Bytes: 1,164,636 Cardinality: 32,351 74 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_APPOINTMENT_TYPE Cost: 3 Bytes: 15 Cardinality: 1 75 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 1,358,742 Cardinality: 64,702 78 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 148 VIEW VIEW SYS.VW_FOJ_1 Cost: 1,687,760 Bytes: 17,976,202,524 Cardinality: 31,317,426 147 HASH JOIN FULL OUTER Cost: 1,687,760 Bytes: 5,762,406,384 Cardinality: 31,317,426 121 VIEW ZZZZZZ_DM. Cost: 47,364 Bytes: 835,433 Cardinality: 8,111 120 SORT GROUP BY Cost: 47,364 Bytes: 1,849,308 Cardinality: 8,111 119 HASH JOIN OUTER Cost: 46,960 Bytes: 1,849,308 Cardinality: 8,111 117 HASH JOIN OUTER Cost: 42,635 Bytes: 25,199 Cardinality: 113 115 HASH JOIN SEMI Cost: 41,142 Bytes: 14,824 Cardinality: 68 111 NESTED LOOPS 109 NESTED LOOPS Cost: 21,526 Bytes: 14,280 Cardinality: 68 107 HASH JOIN SEMI Cost: 21,458 Bytes: 13,396 Cardinality: 68 103 HASH JOIN Cost: 1,283 Bytes: 1,246,048 Cardinality: 6,772 101 HASH JOIN RIGHT OUTER Cost: 1,176 Bytes: 872,093 Cardinality: 5,041 87 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 107,575 Cardinality: 21,515 100 HASH JOIN Cost: 1,071 Bytes: 846,888 Cardinality: 5,041 98 HASH JOIN Cost: 515 Bytes: 681,750 Cardinality: 5,050 88 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DIVISION Cost: 14 Bytes: 5,536 Cardinality: 346 97 HASH JOIN Cost: 500 Bytes: 699,958 Cardinality: 5,882 89 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 6,441 Cardinality: 339 96 HASH JOIN Cost: 497 Bytes: 588,200 Cardinality: 5,882 90 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 6,441 Cardinality: 339 95 HASH JOIN Cost: 493 Bytes: 476,442 Cardinality: 5,882 91 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 38 Cardinality: 2 94 HASH JOIN Cost: 490 Bytes: 2,005,762 Cardinality: 32,351 92 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_APPOINTMENT_TYPE Cost: 3 Bytes: 15 Cardinality: 1 93 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 3,040,994 Cardinality: 64,702 99 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 1,025,442 Cardinality: 31,074 102 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_APPOINTMENT Cost: 106 Bytes: 698,500 Cardinality: 63,500 106 VIEW VIEW SYS.VW_NSO_11 Cost: 20,162 Bytes: 65,950,391 Cardinality: 5,073,107 105 VIEW ZZZZZZ_DM. Cost: 20,162 Bytes: 65,950,391 Cardinality: 5,073,107 104 TABLE ACCESS FULL TABLE (TEMP) SYS.SYS_TEMP_0FD9D6911_E7F3C8 Cost: 20,162 Bytes: 65,950,391 Cardinality: 5,073,107 108 INDEX UNIQUE SCAN INDEX (UNIQUE) ZZZZZZ_DM.IDX_DATE_KEY Cost: 0 Cardinality: 1 110 TABLE ACCESS BY INDEX ROWID TABLE ZZZZZZ_DM.DIM_DATE Cost: 1 Bytes: 13 Cardinality: 1 114 VIEW VIEW SYS.VW_NSO_10 Cost: 19,602 Bytes: 40,584,856 Cardinality: 5,073,107 113 VIEW ZZZZZZ_DM. Cost: 19,602 Bytes: 40,584,856 Cardinality: 5,073,107 112 TABLE ACCESS FULL TABLE (TEMP) SYS.SYS_TEMP_0FD9D6912_E7F3C8 Cost: 19,602 Bytes: 45,657,963 Cardinality: 5,073,107 116 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 260,195 Cardinality: 52,039 118 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 146 VIEW ZZZZZZ_DM. Cost: 1,640,315 Bytes: 2,536,711,506 Cardinality: 31,317,426 145 SORT UNIQUE Cost: 1,640,315 Bytes: 7,359,595,110 Cardinality: 31,317,426 144 HASH JOIN Cost: 48,676 Bytes: 7,359,595,110 Cardinality: 31,317,426 122 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 6,441 Cardinality: 339 143 HASH JOIN Cost: 48,591 Bytes: 6,764,564,016 Cardinality: 31,317,426 123 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 1,025,442 Cardinality: 31,074 142 HASH JOIN Cost: 47,953 Bytes: 5,740,875,249 Cardinality: 31,370,903 139 HASH JOIN Cost: 21,108 Bytes: 46,540,375 Cardinality: 265,945 136 HASH JOIN Cost: 932 Bytes: 1,099,008 Cardinality: 6,784 134 HASH JOIN Cost: 826 Bytes: 762,550 Cardinality: 5,050 132 HASH JOIN Cost: 511 Bytes: 696,900 Cardinality: 5,050 124 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DIVISION Cost: 14 Bytes: 13,148 Cardinality: 346 131 HASH JOIN Cost: 497 Bytes: 588,200 Cardinality: 5,882 125 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 6,441 Cardinality: 339 130 HASH JOIN Cost: 493 Bytes: 476,442 Cardinality: 5,882 126 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 38 Cardinality: 2 129 HASH JOIN Cost: 490 Bytes: 2,005,762 Cardinality: 32,351 127 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_APPOINTMENT_TYPE Cost: 3 Bytes: 15 Cardinality: 1 128 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 3,040,994 Cardinality: 64,702 133 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 1,424,449 Cardinality: 109,573 135 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_APPOINTMENT Cost: 106 Bytes: 698,500 Cardinality: 63,500 138 VIEW ZZZZZZ_DM. Cost: 20,162 Bytes: 65,950,391 Cardinality: 5,073,107 137 TABLE ACCESS FULL TABLE (TEMP) SYS.SYS_TEMP_0FD9D6911_E7F3C8 Cost: 20,162 Bytes: 65,950,391 Cardinality: 5,073,107 141 VIEW ZZZZZZ_DM. Cost: 19,602 Bytes: 40,584,856 Cardinality: 5,073,107 140 TABLE ACCESS FULL TABLE (TEMP) SYS.SYS_TEMP_0FD9D6912_E7F3C8 Cost: 19,602 Bytes: 45,657,963 Cardinality: 5,073,107 388 COUNT STOPKEY 387 VIEW ZZZZZZ_DM. Cost: 1.84467440737096E19 Bytes: 1.84467440737096E19 Cardinality: 1.84467440737096E19 386 WINDOW SORT PUSHED RANK Cost: 1.84467440737096E19 Bytes: 1.84467440737096E19 Cardinality: 1.84467440737096E19 385 MERGE JOIN Cost: 1.84467440737096E19 Bytes: 1.84467440737096E19 Cardinality: 1.84467440737096E19 298 SORT JOIN Cost: 38,493,628,784,822,899 Bytes: 1.84467440737096E19 Cardinality: 1.84467440737096E19 297 MERGE JOIN Cost: 1,240,497,737,955,682 Bytes: 1.84467440737096E19 Cardinality: 1.84467440737096E19 222 SORT JOIN Cost: 34,683,880,903 Bytes: 2,925,948,452,350 Cardinality: 18,999,665,275 221 NESTED LOOPS Cost: 33,810,426,161 Bytes: 2,925,948,452,350 Cardinality: 18,999,665,275 185 VIEW VIEW SYS.VW_NSO_7 Cost: 5,399,034 Bytes: 24,891,097 Cardinality: 323,261 184 HASH UNIQUE Cost: 5,399,034 Bytes: 20,365,443 Cardinality: 323,261 183 HASH JOIN Cost: 186,963 Bytes: 61,413,989,742 Cardinality: 974,825,234 165 VIEW VIEW SYS.VW_NSO_2 Cost: 7,488 Bytes: 396,738 Cardinality: 14,694 164 HASH GROUP BY Cost: 7,488 Bytes: 793,476 Cardinality: 14,694 163 HASH JOIN RIGHT OUTER Cost: 7,310 Bytes: 358,300,368 Cardinality: 6,635,192 153 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 323,510 Cardinality: 64,702 162 HASH JOIN Cost: 6,806 Bytes: 156,409,470 Cardinality: 3,192,030 154 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 559,091 Cardinality: 43,007 161 HASH JOIN OUTER Cost: 6,483 Bytes: 114,958,872 Cardinality: 3,193,302 159 HASH JOIN Cost: 2,154 Bytes: 1,305,472 Cardinality: 42,112 157 HASH JOIN RIGHT OUTER Cost: 661 Bytes: 544,692 Cardinality: 28,668 155 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 107,575 Cardinality: 21,515 156 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 401,352 Cardinality: 28,668 158 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 522,072 Cardinality: 43,506 160 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 182 VIEW ZZZZZZ_DM. Cost: 176,937 Bytes: 238,830,192 Cardinality: 6,634,172 181 HASH GROUP BY Cost: 176,937 Bytes: 743,027,264 Cardinality: 6,634,172 180 HASH JOIN RIGHT OUTER Cost: 8,899 Bytes: 743,027,264 Cardinality: 6,634,172 166 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 323,510 Cardinality: 64,702 179 HASH JOIN RIGHT OUTER Cost: 8,395 Bytes: 341,494,673 Cardinality: 3,191,539 167 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 107,575 Cardinality: 21,515 178 HASH JOIN Cost: 8,281 Bytes: 325,536,978 Cardinality: 3,191,539 168 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_ASSIGN_STATUS Cost: 3 Bytes: 550 Cardinality: 22 177 HASH JOIN Cost: 8,269 Bytes: 245,776,839 Cardinality: 3,191,907 169 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 559,091 Cardinality: 43,007 176 HASH JOIN OUTER Cost: 7,946 Bytes: 204,363,456 Cardinality: 3,193,179 174 HASH JOIN Cost: 2,051 Bytes: 2,484,490 Cardinality: 42,110 170 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 401,352 Cardinality: 28,668 173 HASH JOIN Cost: 1,496 Bytes: 1,957,680 Cardinality: 43,504 171 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_ASSIGNMENT_CATEGORY Cost: 3 Bytes: 115 Cardinality: 5 172 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 957,132 Cardinality: 43,506 175 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 220 VIEW VIEW SYS.VW_NSO_8 Cost: 104,575 Bytes: 4,525,675 Cardinality: 58,775 219 SORT UNIQUE Cost: 104,575 Bytes: 3,408,950 Cardinality: 58,775 218 HASH JOIN Cost: 73,892 Bytes: 354,195,908 Cardinality: 6,106,826 198 VIEW VIEW SYS.VW_NSO_3 Cost: 7,480 Bytes: 396,738 Cardinality: 14,694 197 SORT GROUP BY Cost: 7,480 Bytes: 793,476 Cardinality: 14,694 196 HASH JOIN RIGHT OUTER Cost: 7,306 Bytes: 351,071,010 Cardinality: 6,501,315 186 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 323,510 Cardinality: 64,702 195 HASH JOIN RIGHT OUTER Cost: 6,802 Bytes: 153,253,576 Cardinality: 3,127,624 187 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 260,195 Cardinality: 52,039 194 HASH JOIN OUTER Cost: 5,302 Bytes: 82,329,060 Cardinality: 1,871,115 192 HASH JOIN Cost: 976 Bytes: 961,818 Cardinality: 24,662 190 HASH JOIN Cost: 420 Bytes: 487,500 Cardinality: 19,500 188 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 234,024 Cardinality: 19,502 189 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 559,091 Cardinality: 43,007 191 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 401,352 Cardinality: 28,668 193 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 217 VIEW ZZZZZZ_DM. Cost: 66,396 Bytes: 1,288,360 Cardinality: 41,560 216 SORT GROUP BY Cost: 66,396 Bytes: 4,530,040 Cardinality: 41,560 215 HASH JOIN RIGHT OUTER Cost: 9,477 Bytes: 708,643,335 Cardinality: 6,501,315 199 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 323,510 Cardinality: 64,702 214 HASH JOIN RIGHT OUTER Cost: 8,973 Bytes: 325,272,896 Cardinality: 3,127,624 200 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 260,195 Cardinality: 52,039 213 HASH JOIN Cost: 7,473 Bytes: 185,240,385 Cardinality: 1,871,115 201 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 559,091 Cardinality: 43,007 212 HASH JOIN OUTER Cost: 7,153 Bytes: 160,933,090 Cardinality: 1,871,315 210 HASH JOIN RIGHT OUTER Cost: 1,294 Bytes: 1,997,865 Cardinality: 24,665 202 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_TENURE_STATUS Cost: 3 Bytes: 80 Cardinality: 4 209 HASH JOIN OUTER Cost: 1,290 Bytes: 1,504,565 Cardinality: 24,665 207 HASH JOIN OUTER Cost: 976 Bytes: 1,183,920 Cardinality: 24,665 205 HASH JOIN Cost: 661 Bytes: 863,275 Cardinality: 24,665 203 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 409,542 Cardinality: 19,502 204 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 401,352 Cardinality: 28,668 206 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 1,424,449 Cardinality: 109,573 208 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 1,424,449 Cardinality: 109,573 211 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 296 SORT JOIN Cost: 36,003,135,433,043 Bytes: 2.96358889236731E17 Cardinality: 243,515,931,994,027 295 VIEW VIEW SYS.VW_FOJ_0 Cost: 35,988,800,535,482 Bytes: 2.96358889236731E17 Cardinality: 243,515,931,994,027 294 HASH JOIN FULL OUTER Cost: 35,988,800,535,482 Bytes: 1.74600923239717E17 Cardinality: 243,515,931,994,027 261 VIEW ZZZZZZ_DM. Cost: 17,984,675,973,344 Bytes: 470,301 Cardinality: 1,209 260 HASH GROUP BY Cost: 17,984,675,973,344 Bytes: 372,372 Cardinality: 1,209 259 HASH JOIN OUTER Cost: 17,984,675,973,343 Bytes: 372,372 Cardinality: 1,209 257 NESTED LOOPS 255 NESTED LOOPS Cost: 17,984,675,969,017 Bytes: 5,151 Cardinality: 17 253 NESTED LOOPS Cost: 17,984,675,969,000 Bytes: 4,930 Cardinality: 17 250 NESTED LOOPS Cost: 17,984,675,968,983 Bytes: 4,709 Cardinality: 17 247 HASH JOIN SEMI Cost: 17,984,675,968,966 Bytes: 4,488 Cardinality: 17 243 HASH JOIN Cost: 2,758 Bytes: 423,437 Cardinality: 1,687 241 HASH JOIN Cost: 2,672 Bytes: 298,144 Cardinality: 1,232 223 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DIVISION Cost: 14 Bytes: 13,148 Cardinality: 346 240 HASH JOIN Cost: 2,658 Bytes: 292,740 Cardinality: 1,435 224 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 6,441 Cardinality: 339 239 HASH JOIN Cost: 2,654 Bytes: 265,475 Cardinality: 1,435 225 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 76 Cardinality: 4 238 HASH JOIN Cost: 2,651 Bytes: 1,727,562 Cardinality: 10,407 236 HASH JOIN Cost: 2,164 Bytes: 655,917 Cardinality: 5,007 226 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_ASSIGN_STATUS Cost: 3 Bytes: 500 Cardinality: 20 235 HASH JOIN Cost: 2,161 Bytes: 556,076 Cardinality: 5,246 227 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_ASSIGNMENT_CATEGORY Cost: 3 Bytes: 46 Cardinality: 2 234 HASH JOIN Cost: 2,157 Bytes: 1,088,462 Cardinality: 13,114 232 HASH JOIN Cost: 665 Bytes: 494,298 Cardinality: 7,846 230 HASH JOIN Cost: 109 Bytes: 224,109 Cardinality: 6,057 228 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_TENURE_STATUS Cost: 3 Bytes: 20 Cardinality: 1 229 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 308,907 Cardinality: 18,171 231 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 807,924 Cardinality: 31,074 233 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 1,040,780 Cardinality: 52,039 237 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 2,264,570 Cardinality: 64,702 242 INDEX FAST FULL SCAN INDEX ZZZZZZ_DM.IDX_APPT_VER_CURR Cost: 85 Bytes: 582,318 Cardinality: 64,702 246 VIEW VIEW SYS.VW_NSO_1 Cost: 17,936,020,196,526 Bytes: 2.42973241918748E17 Cardinality: 18,690,249,378,365,203 245 VIEW ZZZZZZ_DM. Cost: 17,936,020,196,526 Bytes: 2.42973241918748E17 Cardinality: 18,690,249,378,365,203 244 TABLE ACCESS FULL TABLE (TEMP) SYS.SYS_TEMP_0FD9D6913_E7F3C8 Cost: 17,936,020,196,526 Bytes: 2.42973241918748E17 Cardinality: 18,690,249,378,365,203 249 TABLE ACCESS BY INDEX ROWID TABLE ZZZZZZ_DM.DIM_DATE Cost: 1 Bytes: 13 Cardinality: 1 248 INDEX UNIQUE SCAN INDEX (UNIQUE) ZZZZZZ_DM.IDX_DATE_KEY Cost: 0 Cardinality: 1 252 TABLE ACCESS BY INDEX ROWID TABLE ZZZZZZ_DM.DIM_DATE Cost: 1 Bytes: 13 Cardinality: 1 251 INDEX UNIQUE SCAN INDEX (UNIQUE) ZZZZZZ_DM.IDX_DATE_KEY Cost: 0 Cardinality: 1 254 INDEX UNIQUE SCAN INDEX (UNIQUE) ZZZZZZ_DM.IDX_DATE_KEY Cost: 0 Cardinality: 1 256 TABLE ACCESS BY INDEX ROWID TABLE ZZZZZZ_DM.DIM_DATE Cost: 1 Bytes: 13 Cardinality: 1 258 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 293 VIEW ZZZZZZ_DM. Cost: 18,003,490,624,363 Bytes: 79,873,225,693,644,301 Cardinality: 243,515,931,992,818 292 HASH UNIQUE Cost: 18,003,490,624,363 Bytes: 75,489,938,917,773,581 Cardinality: 243,515,931,992,818 291 HASH JOIN Cost: 17,984,675,969,909 Bytes: 75,489,938,917,773,581 Cardinality: 243,515,931,992,818 288 HASH JOIN Cost: 3,702 Bytes: 500,742 Cardinality: 1,686 286 HASH JOIN Cost: 3,387 Bytes: 478,824 Cardinality: 1,686 284 HASH JOIN Cost: 3,073 Bytes: 456,906 Cardinality: 1,686 282 HASH JOIN Cost: 2,758 Bytes: 435,246 Cardinality: 1,687 280 HASH JOIN Cost: 2,672 Bytes: 306,768 Cardinality: 1,232 262 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_ASSIGN_STATUS Cost: 3 Bytes: 500 Cardinality: 20 279 HASH JOIN Cost: 2,669 Bytes: 289,184 Cardinality: 1,291 263 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_ASSIGNMENT_CATEGORY Cost: 3 Bytes: 46 Cardinality: 2 278 HASH JOIN Cost: 2,665 Bytes: 648,828 Cardinality: 3,228 276 HASH JOIN Cost: 1,173 Bytes: 349,511 Cardinality: 1,931 264 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DIVISION Cost: 14 Bytes: 13,148 Cardinality: 346 275 HASH JOIN Cost: 1,158 Bytes: 321,607 Cardinality: 2,249 265 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 6,441 Cardinality: 339 274 HASH JOIN Cost: 1,155 Bytes: 278,876 Cardinality: 2,249 266 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 76 Cardinality: 4 273 HASH JOIN Cost: 1,151 Bytes: 1,712,445 Cardinality: 16,309 271 HASH JOIN Cost: 665 Bytes: 549,220 Cardinality: 7,846 269 HASH JOIN Cost: 109 Bytes: 224,109 Cardinality: 6,057 267 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_TENURE_STATUS Cost: 3 Bytes: 20 Cardinality: 1 268 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 308,907 Cardinality: 18,171 270 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 1,025,442 Cardinality: 31,074 272 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 2,264,570 Cardinality: 64,702 277 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 1,040,780 Cardinality: 52,039 281 INDEX FAST FULL SCAN INDEX ZZZZZZ_DM.IDX_APPT_VER_CURR Cost: 85 Bytes: 582,318 Cardinality: 64,702 283 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 1,424,449 Cardinality: 109,573 285 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 559,091 Cardinality: 43,007 287 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 1,424,449 Cardinality: 109,573 290 VIEW ZZZZZZ_DM. Cost: 17,936,020,196,526 Bytes: 2.42973241918748E17 Cardinality: 18,690,249,378,365,203 289 TABLE ACCESS FULL TABLE (TEMP) SYS.SYS_TEMP_0FD9D6913_E7F3C8 Cost: 17,936,020,196,526 Bytes: 2.42973241918748E17 Cardinality: 18,690,249,378,365,203 384 SORT JOIN Cost: 13,839,679,968 Bytes: 312,987,006,533,322 Cardinality: 1,588,766,530,626 383 VIEW VIEW SYS.VW_NSO_9 Cost: 10,601,207,748 Bytes: 312,987,006,533,322 Cardinality: 1,588,766,530,626 382 HASH UNIQUE Cost: 10,601,207,748 Bytes: 333,640,971,431,460 Cardinality: 1,588,766,530,626 381 VIEW ZZZZZZ_DM. Cost: 210,961,679 Bytes: 333,640,971,431,460 Cardinality: 1,588,766,530,626 380 WINDOW SORT PUSHED RANK Cost: 210,961,679 Bytes: 1,069,239,875,111,298 Cardinality: 1,588,766,530,626 379 HASH JOIN Cost: 6,915,069 Bytes: 1,069,239,875,111,298 Cardinality: 1,588,766,530,626 316 VIEW VIEW SYS.VW_NSO_6 Cost: 132,670 Bytes: 238,436,029 Cardinality: 5,073,107 315 HASH UNIQUE Cost: 132,670 Bytes: 547,895,556 Cardinality: 5,073,107 314 HASH GROUP BY Cost: 132,670 Bytes: 547,895,556 Cardinality: 5,073,107 313 HASH JOIN RIGHT OUTER Cost: 8,963 Bytes: 547,895,556 Cardinality: 5,073,107 299 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 260,195 Cardinality: 52,039 312 HASH JOIN Cost: 7,458 Bytes: 312,605,927 Cardinality: 3,035,009 300 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_APPOINTMENT Cost: 106 Bytes: 698,500 Cardinality: 63,500 311 HASH JOIN RIGHT OUTER Cost: 7,343 Bytes: 207,863,420 Cardinality: 2,259,385 301 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 107,575 Cardinality: 21,515 310 HASH JOIN Cost: 7,231 Bytes: 196,566,495 Cardinality: 2,259,385 302 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 559,091 Cardinality: 43,007 309 HASH JOIN OUTER Cost: 6,911 Bytes: 167,196,858 Cardinality: 2,259,417 307 HASH JOIN Cost: 1,046 Bytes: 2,055,924 Cardinality: 29,796 303 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 946,044 Cardinality: 28,668 306 HASH JOIN Cost: 490 Bytes: 1,164,636 Cardinality: 32,351 304 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_APPOINTMENT_TYPE Cost: 3 Bytes: 15 Cardinality: 1 305 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 1,358,742 Cardinality: 64,702 308 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 378 VIEW VIEW SYS.VW_FOJ_2 Cost: 1,687,760 Bytes: 19,604,708,676 Cardinality: 31,317,426 377 HASH JOIN FULL OUTER Cost: 1,687,760 Bytes: 7,390,912,536 Cardinality: 31,317,426 351 VIEW ZZZZZZ_DM. Cost: 47,364 Bytes: 835,433 Cardinality: 8,111 350 HASH GROUP BY Cost: 47,364 Bytes: 1,849,308 Cardinality: 8,111 349 HASH JOIN OUTER Cost: 46,960 Bytes: 1,849,308 Cardinality: 8,111 347 HASH JOIN OUTER Cost: 42,635 Bytes: 25,199 Cardinality: 113 345 HASH JOIN SEMI Cost: 41,142 Bytes: 14,824 Cardinality: 68 341 NESTED LOOPS 339 NESTED LOOPS Cost: 21,526 Bytes: 14,280 Cardinality: 68 337 HASH JOIN SEMI Cost: 21,458 Bytes: 13,396 Cardinality: 68 333 HASH JOIN Cost: 1,283 Bytes: 1,246,048 Cardinality: 6,772 331 HASH JOIN RIGHT OUTER Cost: 1,176 Bytes: 872,093 Cardinality: 5,041 317 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_TENURE_EVENT Cost: 105 Bytes: 107,575 Cardinality: 21,515 330 HASH JOIN Cost: 1,071 Bytes: 846,888 Cardinality: 5,041 328 HASH JOIN Cost: 515 Bytes: 681,750 Cardinality: 5,050 318 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DIVISION Cost: 14 Bytes: 5,536 Cardinality: 346 327 HASH JOIN Cost: 500 Bytes: 699,958 Cardinality: 5,882 319 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 6,441 Cardinality: 339 326 HASH JOIN Cost: 497 Bytes: 588,200 Cardinality: 5,882 320 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 6,441 Cardinality: 339 325 HASH JOIN Cost: 493 Bytes: 476,442 Cardinality: 5,882 321 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 38 Cardinality: 2 324 HASH JOIN Cost: 490 Bytes: 2,005,762 Cardinality: 32,351 322 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_APPOINTMENT_TYPE Cost: 3 Bytes: 15 Cardinality: 1 323 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 3,040,994 Cardinality: 64,702 329 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 1,025,442 Cardinality: 31,074 332 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_APPOINTMENT Cost: 106 Bytes: 698,500 Cardinality: 63,500 336 VIEW VIEW SYS.VW_NSO_5 Cost: 20,162 Bytes: 65,950,391 Cardinality: 5,073,107 335 VIEW ZZZZZZ_DM. Cost: 20,162 Bytes: 65,950,391 Cardinality: 5,073,107 334 TABLE ACCESS FULL TABLE (TEMP) SYS.SYS_TEMP_0FD9D690F_E7F3C8 Cost: 20,162 Bytes: 65,950,391 Cardinality: 5,073,107 338 INDEX UNIQUE SCAN INDEX (UNIQUE) ZZZZZZ_DM.IDX_DATE_KEY Cost: 0 Cardinality: 1 340 TABLE ACCESS BY INDEX ROWID TABLE ZZZZZZ_DM.DIM_DATE Cost: 1 Bytes: 13 Cardinality: 1 344 VIEW VIEW SYS.VW_NSO_4 Cost: 19,602 Bytes: 40,584,856 Cardinality: 5,073,107 343 VIEW ZZZZZZ_DM. Cost: 19,602 Bytes: 40,584,856 Cardinality: 5,073,107 342 TABLE ACCESS FULL TABLE (TEMP) SYS.SYS_TEMP_0FD9D6910_E7F3C8 Cost: 19,602 Bytes: 45,657,963 Cardinality: 5,073,107 346 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_ASSIGNMENT Cost: 1,492 Bytes: 260,195 Cardinality: 52,039 348 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_SALARY Cost: 4,321 Bytes: 8,827,970 Cardinality: 1,765,594 376 VIEW ZZZZZZ_DM. Cost: 1,640,315 Bytes: 4,165,217,658 Cardinality: 31,317,426 375 HASH UNIQUE Cost: 1,640,315 Bytes: 7,359,595,110 Cardinality: 31,317,426 374 HASH JOIN Cost: 48,676 Bytes: 7,359,595,110 Cardinality: 31,317,426 352 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 6,441 Cardinality: 339 373 HASH JOIN Cost: 48,591 Bytes: 6,764,564,016 Cardinality: 31,317,426 353 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_EMPLOYEE Cost: 555 Bytes: 1,025,442 Cardinality: 31,074 372 HASH JOIN Cost: 47,953 Bytes: 5,740,875,249 Cardinality: 31,370,903 369 HASH JOIN Cost: 21,108 Bytes: 46,540,375 Cardinality: 265,945 366 HASH JOIN Cost: 932 Bytes: 1,099,008 Cardinality: 6,784 364 HASH JOIN Cost: 826 Bytes: 762,550 Cardinality: 5,050 362 HASH JOIN Cost: 511 Bytes: 696,900 Cardinality: 5,050 354 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DIVISION Cost: 14 Bytes: 13,148 Cardinality: 346 361 HASH JOIN Cost: 497 Bytes: 588,200 Cardinality: 5,882 355 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 6,441 Cardinality: 339 360 HASH JOIN Cost: 493 Bytes: 476,442 Cardinality: 5,882 356 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_RANK Cost: 3 Bytes: 38 Cardinality: 2 359 HASH JOIN Cost: 490 Bytes: 2,005,762 Cardinality: 32,351 357 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_APPOINTMENT_TYPE Cost: 3 Bytes: 15 Cardinality: 1 358 TABLE ACCESS FULL TABLE ZZZZZZ_DM.FCT_QQQQQ_APPOINTMENT Cost: 486 Bytes: 3,040,994 Cardinality: 64,702 363 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_DATE Cost: 314 Bytes: 1,424,449 Cardinality: 109,573 365 TABLE ACCESS FULL TABLE ZZZZZZ_DM.DIM_QQQQQ_APPOINTMENT Cost: 106 Bytes: 698,500 Cardinality: 63,500 368 VIEW ZZZZZZ_DM. Cost: 20,162 Bytes: 65,950,391 Cardinality: 5,073,107 367 TABLE ACCESS FULL TABLE (TEMP) SYS.SYS_TEMP_0FD9D690F_E7F3C8 Cost: 20,162 Bytes: 65,950,391 Cardinality: 5,073,107 371 VIEW ZZZZZZ_DM. Cost: 19,602 Bytes: 40,584,856 Cardinality: 5,073,107 370 TABLE ACCESS FULL TABLE (TEMP) SYS.SYS_TEMP_0FD9D6910_E7F3C8 Cost: 19,602 Bytes: 45,657,963 Cardinality: 5,073,107