{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "GO_BRANCH_DIM",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "SQL131018160540360"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["BRANCH_KEY"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "GO_REGION_DIM",
      "access_type": "ALL",
      "rows": 21,
      "filtered": 100,
      "attached_condition": "go_region_dim.REGION_CODE = 740"
    },
    "block-nl-join": {
      "table": {
        "table_name": "SLS_PRODUCT_DIM",
        "access_type": "ALL",
        "possible_keys": ["PRIMARY", "SQL131018160555680"],
        "rows": 274,
        "filtered": 100
      },
      "buffer_type": "flat",
      "buffer_size": "217",
      "join_type": "BNL",
      "attached_condition": "sls_product_dim.PRODUCT_COLOR_CODE is not null and sls_product_dim.PRODUCT_BRAND_CODE is not null and sls_product_dim.PRODUCT_SIZE_CODE is not null"
    },
    "table": {
      "table_name": "SLS_PRODUCT_TYPE_LOOKUP",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160557050"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["PRODUCT_TYPE_CODE"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_TYPE_CODE"],
      "rows": 1,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "SLS_PRODUCT_LINE_LOOKUP",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160555930"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["PRODUCT_LINE_CODE"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_LINE_CODE"],
      "rows": 1,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "SLS_PRODUCT_COLOR_LOOKUP",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160555400"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["PRODUCT_COLOR_CODE"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_COLOR_CODE"],
      "rows": 1,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "SLS_PRODUCT_BRAND_LOOKUP",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160555130"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["PRODUCT_BRAND_CODE"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_BRAND_CODE"],
      "rows": 1,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "SLS_PRODUCT_SIZE_LOOKUP",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160556800"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["PRODUCT_SIZE_CODE"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_SIZE_CODE"],
      "rows": 1,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "SLS_PRODUCT_DIM",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160555680"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["PRODUCT_KEY"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_KEY"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "sls_product_dim.PRODUCT_TYPE_KEY = 961 and sls_product_dim.PRODUCT_BRAND_CODE is not null and sls_product_dim.PRODUCT_COLOR_CODE is not null and sls_product_dim.PRODUCT_SIZE_CODE is not null"
    },
    "table": {
      "table_name": "SLS_PRODUCT_BRAND_LOOKUP",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160555130"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["PRODUCT_BRAND_CODE"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_BRAND_CODE"],
      "rows": 1,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "SLS_PRODUCT_COLOR_LOOKUP",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160555400"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["PRODUCT_COLOR_CODE"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_COLOR_CODE"],
      "rows": 1,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "SLS_PRODUCT_SIZE_LOOKUP",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160556800"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["PRODUCT_SIZE_CODE"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_SIZE_CODE"],
      "rows": 1,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "SLS_PRODUCT_LINE_LOOKUP",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160555930"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["PRODUCT_LINE_CODE"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_LINE_CODE"],
      "rows": 1,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "SLS_PRODUCT_TYPE_LOOKUP",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160557050"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["PRODUCT_TYPE_CODE"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_TYPE_CODE"],
      "rows": 1,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "SLS_PRODUCT_LOOKUP",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160556220"],
      "key": "PRIMARY",
      "key_length": "96",
      "used_key_parts": ["PRODUCT_NUMBER", "PRODUCT_LANGUAGE"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_NUMBER", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "sls_product_lookup.PRODUCT_LANGUAGE = 'EN'",
      "using_index": true
    },
    "table": {
      "table_name": "SLS_PRODUCT_LOOKUP",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160556220"],
      "key": "PRIMARY",
      "key_length": "96",
      "used_key_parts": ["PRODUCT_NUMBER", "PRODUCT_LANGUAGE"],
      "ref": ["gosalesdw_1021.SLS_PRODUCT_DIM.PRODUCT_NUMBER", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "sls_product_lookup.PRODUCT_LANGUAGE = 'EN'",
      "using_index": true
    },
    "block-nl-join": {
      "table": {
        "table_name": "GO_TIME_DIM",
        "access_type": "ALL",
        "possible_keys": ["PRIMARY", "SQL131018160542120"],
        "rows": 1413,
        "filtered": 100
      },
      "buffer_type": "flat",
      "buffer_size": "2047Kb",
      "join_type": "BNL"
    },
    "table": {
      "table_name": "SLS_SALES_FACT",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "SQL131018160557610"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["ORDER_DAY_KEY"],
      "ref": ["gosalesdw_1021.GO_TIME_DIM.DAY_KEY"],
      "rows": 503,
      "filtered": 100,
      "attached_condition": "sls_sales_fact.PRODUCT_KEY = sls_product_dim.PRODUCT_KEY"
    },
    "table": {
      "table_name": "SLS_RETAILER_DIM",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160557300"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["RETAILER_SITE_KEY"],
      "ref": ["gosalesdw_1021.SLS_SALES_FACT.RETAILER_SITE_KEY"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "sls_retailer_dim.RTL_COUNTRY_CODE = go_region_dim.COUNTRY_CODE"
    },
    "table": {
      "table_name": "EMP_EMPLOYEE_DIM",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "SQL131018160520020"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["EMPLOYEE_KEY"],
      "ref": ["gosalesdw_1021.SLS_SALES_FACT.EMPLOYEE_KEY"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "emp_employee_dim.BRANCH_CODE = 40"
    },
    "table": {
      "table_name": "<derived8>",
      "access_type": "ref",
      "possible_keys": ["key0"],
      "key": "key0",
      "key_length": "4",
      "used_key_parts": ["Retailer_key"],
      "ref": ["gosalesdw_1021.SLS_RETAILER_DIM.RETAILER_KEY"],
      "rows": 10,
      "filtered": 100,
      "attached_condition": "retailer.Retailer_type_code = 7",
      "materialized": {
        "query_block": {
          "select_id": 8,
          "filesort": {
            "sort_key": "sls_retailer_dim.RETAILER_KEY",
            "temporary_table": {
              "table": {
                "table_name": "SLS_RETAILER_DIM",
                "access_type": "ALL",
                "rows": 762,
                "filtered": 100,
                "attached_condition": "sls_retailer_dim.RETAILER_TYPE_CODE = 7"
              }
            }
          }
        }
      }
    }
  }
}