| Sort | |
| collation: [C_LAST_NAME ASC, C_FIRST_NAME ASC, EXPR$2 ASC, PROFIT ASC] | |
| fetch: 100 | |
| est: (rows=100) | |
| Project | |
| fieldNames: [C_LAST_NAME, C_FIRST_NAME, EXPR$2, SS_TICKET_NUMBER, AMT, PROFIT] | |
| projection: [C_LAST_NAME, C_FIRST_NAME, SUBSTR(S_CITY, 1, 30), SS_TICKET_NUMBER, AMT, PROFIT] | |
| est: (rows=53849) | |
| HashJoin | |
| predicate: =(SS_CUSTOMER_SK, C_CUSTOMER_SK) | |
| type: inner | |
| est: (rows=53849) | |
| Exchange | |
| distribution: single | |
| est: (rows=100000) | |
| TableScan | |
| table: PUBLIC.CUSTOMER | |
| fieldNames: [C_CUSTOMER_SK, C_FIRST_NAME, C_LAST_NAME] | |
| est: (rows=100000) | |
| Project | |
| fieldNames: [SS_TICKET_NUMBER, SS_CUSTOMER_SK, S_CITY, AMT, PROFIT] | |
| projection: [SS_TICKET_NUMBER, SS_CUSTOMER_SK, S_CITY, AMT, PROFIT] | |
| est: (rows=53849) | |
| ColocatedHashAggregate | |
| fieldNames: [SS_TICKET_NUMBER, SS_CUSTOMER_SK, SS_ADDR_SK, S_CITY, AMT, PROFIT] | |
| group: [SS_TICKET_NUMBER, SS_CUSTOMER_SK, SS_ADDR_SK, S_CITY] | |
| aggregation: [SUM(SS_COUPON_AMT), SUM(SS_NET_PROFIT)] | |
| est: (rows=53849) | |
| Project | |
| fieldNames: [SS_TICKET_NUMBER, SS_CUSTOMER_SK, SS_ADDR_SK, S_CITY, SS_COUPON_AMT, SS_NET_PROFIT] | |
| projection: [SS_TICKET_NUMBER, SS_CUSTOMER_SK, SS_ADDR_SK, S_CITY, SS_COUPON_AMT, SS_NET_PROFIT] | |
| est: (rows=91208) | |
| HashJoin | |
| predicate: =(SS_HDEMO_SK, HD_DEMO_SK) | |
| type: inner | |
| est: (rows=91208) | |
| HashJoin | |
| predicate: =(SS_SOLD_DATE_SK, D_DATE_SK) | |
| type: inner | |
| est: (rows=182417) | |
| HashJoin | |
| predicate: =(SS_STORE_SK, S_STORE_SK) | |
| type: inner | |
| est: (rows=720101) | |
| Exchange | |
| distribution: single | |
| est: (rows=2880404) | |
| TableScan | |
| table: PUBLIC.STORE_SALES | |
| fieldNames: [SS_SOLD_DATE_SK, SS_CUSTOMER_SK, SS_HDEMO_SK, SS_ADDR_SK, SS_STORE_SK, SS_TICKET_NUMBER, SS_COUPON_AMT, SS_NET_PROFIT] | |
| est: (rows=2880404) | |
| Exchange | |
| distribution: single | |
| est: (rows=3) | |
| TableScan | |
| table: PUBLIC.STORE | |
| predicate: SEARCH(S_NUMBER_EMPLOYEES, Sarg[[200..295]]) | |
| fieldNames: [S_STORE_SK, S_NUMBER_EMPLOYEES, S_CITY] | |
| est: (rows=3) | |
| Exchange | |
| distribution: single | |
| est: (rows=18505) | |
| TableScan | |
| table: PUBLIC.DATE_DIM | |
| predicate: AND(=(D_DOW, 1), SEARCH(D_YEAR, Sarg[1998, 1999, 2000])) | |
| fieldNames: [D_DATE_SK, D_YEAR, D_DOW] | |
| est: (rows=18505) | |
| Exchange | |
| distribution: single | |
| est: (rows=3600) | |
| TableScan | |
| table: PUBLIC.HOUSEHOLD_DEMOGRAPHICS | |
| predicate: OR(=(HD_DEP_COUNT, 0), >(HD_VEHICLE_COUNT, 3)) | |
| fieldNames: [HD_DEMO_SK, HD_DEP_COUNT, HD_VEHICLE_COUNT] | |
| est: (rows=3600) |