page211
297
CREATE OR REPLACE TABLE part_customer_order_asia
(
customer_key NUMBER(38,0),
customer_name VARCHAR(25),
order_key NUMBER(38,0),
order_date DATE,
nation_name VARCHAR(25),
region_name VARCHAR(25)
);
CREATE OR REPLACE TABLE part_customer_order_europe
(
customer_key NUMBER(38,0),
customer_name VARCHAR(25),
order_key NUMBER(38,0),
order_date DATE,
nation_name VARCHAR(25),
region_name VARCHAR(25)
);
CREATE OR REPLACE TABLE part_customer_order_africa
(
customer_key NUMBER(38,0),
customer_name VARCHAR(25),
order_key NUMBER(38,0),
order_date DATE,
nation_name VARCHAR(25),
region_name VARCHAR(25)
);
CREATE OR REPLACE TABLE part_customer_order_america
(
customer_key NUMBER(38,0),
customer_name VARCHAR(25),
order_key NUMBER(38,0),
order_date DATE,
Chapter 8
parallelization