Currently for testing purpose the indexes only exist on
zip, age, gender, income_cd, regions, income and state and all of them are bitmap indexes.


CREATE TABLE customer(
regions NUMBER(2),
zip CHAR(5),
zip4 CHAR(5),
cc_bank CHAR(1),
cc_dept CHAR(1),
loan_ind CHAR(1),
cc_prem CHAR(1),
cc_upscl CHAR(1),
ethnic CHAR(1),
prefix CHAR(1),
f_name CHAR(13),
m_init CHAR(1),
l_name CHAR(16),
apart_ind CHAR(1),
pobox_ind CHAR(1),
urban CHAR(28),
filler CHAR(1),
city CHAR(20),
state CHAR(2),
income NUMBER(4),
income_cd CHAR(1),
single CHAR(1),
avg_prm_dt CHAR(6),
avg_mtch CHAR(2),
don_plan1 CHAR(1),
don_plan2 CHAR(1),
don_maj1 CHAR(1),
don_maj2 CHAR(1),
don_lklyhd CHAR(2),
don_dol_cd CHAR(1),
student CHAR(1),
student_ln CHAR(1),
avg_st_hcr CHAR(8),
dpbc CHAR(3),
hhld_id CHAR(5),
indiv_id CHAR(5),
occupation CHAR(4),
loan_type CHAR(1),
mfdu CHAR(1),
vendor_tag CHAR(1),
mve_rng CHAR(1),
head_hhld CHAR(1),
gender CHAR(1),
driver CHAR(1),
crrt CHAR(5),
mob CHAR(1),
mortgage1 CHAR(1),
mortgage2 CHAR(1),
auto_loan1 CHAR(1),
auto_loan2 CHAR(1),
age NUMBER(3),
age_ind CHAR(1),
dob_year CHAR(4),
dob_mon CHAR(2),
avg_age CHAR(3),
child_ind CHAR(1),
child1 CHAR(1),
child2 CHAR(1),
child3 CHAR(1),
child_num NUMBER(1),
l_sec_crd NUMBER(5),
l_fin_crd NUMBER(4),
geo_state CHAR(2),
geo_county CHAR(3),
geo_census CHAR(6),
geo_bl_grp CHAR(1),
smac CHAR(1),
msa CHAR(4),
adi CHAR(3),
dma CHAR(3),
curadd_dt CHAR(6),
lor NUMBER(2),
date_rept CHAR(6),
apart_no CHAR(5),
listid CHAR(12),
sum_old_tr NUMBER(4,1),
sum_pb_no NUMBER(4,1),
sum_bc_tr NUMBER(4,1),
sum_pb_bal NUMBER(7,1),
sum_bc_bal NUMBER(7,1),
sum_pf_tr NUMBER(4,1),
sum_pf_bal NUMBER(7,1),
sum_mt_tr NUMBER(4,1),
sum_mt_bal NUMBER(7,1),
sum_rt_bal NUMBER(7,1),
sum_ur_bal NUMBER(7,1),
a_auto_dt CHAR(6),
a_auto_hc CHAR(8),
a_mort_dt CHAR(6),
a_mort_hc CHAR(8),
a_home_val CHAR(10),
a_home_eqt CHAR(10),
hme_value CHAR(10),
hme_val_cd CHAR(1),
hme_owner CHAR(1),
refin_mdl NUMBER(5),
fin_306090 CHAR(1),
affinity CHAR(1),
kob1 CHAR(1),
kob2 CHAR(1),
kob3 CHAR(1),
kob4 CHAR(1),
kob5 CHAR(1),
kob6 CHAR(1),
kob7 CHAR(1),
ext_howner CHAR(1),
condo CHAR(1),
mort_amt NUMBER(6),
mort_opdt CHAR(6),
rec_freq CHAR(1),
rec_w30 CHAR(1),
rec_w60 CHAR(1),
rec_w90 CHAR(1),
rec_w120 CHAR(1),
rec_w150 CHAR(1),
rec_w180 CHAR(1),
solo CHAR(3),
hme_own_fl CHAR(1),
direct_buy CHAR(1),
hhld_zip4 CHAR(4),
ext_hownr2 CHAR(1),
mve_add_dt CHAR(6),
mve_eff_dt CHAR(6),
inst_addr CHAR(1),
executive CHAR(1),
phone_ind CHAR(1),
title CHAR(6),
seq_num CHAR(9),
panel CHAR(3),
pm_box CHAR(12),
list_num_b CHAR(3),
address CHAR(30),
filler2 CHAR(3),
zip_act_cd CHAR(1),
coa_index CHAR(1),
add_type CHAR(1),
ncoa_nixie CHAR(1),
sec_add CHAR(12),
aci_hh_id CHAR(15)) NOLOGGING
PARTITION BY RANGE(regions)
(PARTITION P1 VALUES LESS THAN (2) TABLESPACE P1
STORAGE(INITIAL 1024M NEXT 1024M MINEXTENTS 16
MAXEXTENTS UNLIMITED PCTINCREASE 0)
PCTFREE 5 PCTUSED 90,
PARTITION P2 VALUES LESS THAN (3) TABLESPACE P2
STORAGE(INITIAL 2047M NEXT 2047M MINEXTENTS 5
MAXEXTENTS UNLIMITED PCTINCREASE 0)
PCTFREE 5 PCTUSED 90,
PARTITION P3 VALUES LESS THAN (4) TABLESPACE P3
STORAGE(INITIAL 1023M NEXT 1023M MINEXTENTS 10
MAXEXTENTS UNLIMITED PCTINCREASE 0)
PCTFREE 5 PCTUSED 90,
PARTITION P4 VALUES LESS THAN (5) TABLESPACE P4
STORAGE(INITIAL 1023M NEXT 1023M MINEXTENTS 8
MAXEXTENTS UNLIMITED PCTINCREASE 0)
PCTFREE 5 PCTUSED 90,
PARTITION P5 VALUES LESS THAN (6) TABLESPACE P5
STORAGE(INITIAL 2047M NEXT 2047M MINEXTENTS 7
MAXEXTENTS UNLIMITED PCTINCREASE 0)
PCTFREE 5 PCTUSED 90,
PARTITION P6 VALUES LESS THAN (7) TABLESPACE P6
STORAGE(INITIAL 1023M NEXT 1023M MINEXTENTS 13
MAXEXTENTS UNLIMITED PCTINCREASE 0)
PCTFREE 5 PCTUSED 90,
PARTITION P7 VALUES LESS THAN (8) TABLESPACE P7
STORAGE(INITIAL 1023M NEXT 1023M MINEXTENTS 7
MAXEXTENTS UNLIMITED PCTINCREASE 0)
PCTFREE 5 PCTUSED 90,
PARTITION P8 VALUES LESS THAN (9) TABLESPACE P8
STORAGE(INITIAL 2047M NEXT 2047M MINEXTENTS 6
MAXEXTENTS UNLIMITED PCTINCREASE 0)
PCTFREE 5 PCTUSED 90,
PARTITION P9 VALUES LESS THAN (MAXVALUE)
TABLESPACE P9
STORAGE(INITIAL 2047M NEXT 2047M MINEXTENTS 6
MAXEXTENTS UNLIMITED PCTINCREASE 0)
PCTFREE 5 PCTUSED 90);