CREATE INDEX i_account_num ON customer ( account_num ); CREATE INDEX i_fname ON customer ( fname ); CREATE INDEX i_lname ON customer ( lname ); CREATE INDEX i_num_children_at_home ON customer ( num_children_at_home ); CREATE UNIQUE INDEX i_customer_id ON customer ( customer_id ); CREATE INDEX i_postal_code ON customer ( postal_code ); CREATE INDEX i_customer_region_id ON customer ( customer_region_id ); CREATE INDEX i_product_id ON inventory_fact_1997 ( product_id ); CREATE INDEX i_store_id ON inventory_fact_1997 ( store_id ); CREATE INDEX i_time_id ON inventory_fact_1997 ( time_id ); CREATE INDEX i_warehouse_key ON inventory_fact_1997 ( warehouse_key ); CREATE INDEX i_product_id ON inventory_fact_1998 ( product_id ); CREATE INDEX i_store_id ON inventory_fact_1998 ( store_id ); CREATE INDEX i_time_id ON inventory_fact_1998 ( time_id ); CREATE INDEX i_warehouse_key ON inventory_fact_1998 ( warehouse_key ); CREATE INDEX i_brand_name ON product ( brand_name ); CREATE UNIQUE INDEX i_product_id ON product ( product_id ); CREATE INDEX i_product_class_id ON product ( product_class_id ); CREATE INDEX i_product_name ON product ( product_name ); CREATE INDEX i_SKU ON product ( SKU ); CREATE UNIQUE INDEX i_promotion_id ON promotion ( promotion_id ); CREATE INDEX i_promotion_district_id ON promotion ( promotion_district_id ); CREATE INDEX i_customer_id ON sales_fact_1997 ( customer_id ); CREATE INDEX i_product_id ON sales_fact_1997 ( product_id ); CREATE INDEX i_promotion_id ON sales_fact_1997 ( promotion_id ); CREATE INDEX i_store_id ON sales_fact_1997 ( store_id ); CREATE INDEX i_time_id ON sales_fact_1997 ( time_id ); CREATE INDEX i_customer_id ON sales_fact_dec_1998 ( customer_id ); CREATE INDEX i_product_id ON sales_fact_dec_1998 ( product_id ); CREATE INDEX i_promotion_id ON sales_fact_dec_1998 ( promotion_id ); CREATE INDEX i_store_id ON sales_fact_dec_1998 ( store_id ); CREATE INDEX i_time_id ON sales_fact_dec_1998 ( time_id ); CREATE INDEX i_customer_id ON sales_fact_1998 ( customer_id ); CREATE INDEX i_product_id ON sales_fact_1998 ( product_id ); CREATE INDEX i_promotion_id ON sales_fact_1998 ( promotion_id ); CREATE INDEX i_store_id ON sales_fact_1998 ( store_id ); CREATE INDEX i_time_id ON sales_fact_1998 ( time_id ); CREATE UNIQUE INDEX i_store_id ON store ( store_id ); CREATE INDEX i_region_id ON store ( region_id );
# | Change | User | Description | Committed | |
---|---|---|---|---|---|
#3 | 1583 | Julian Hyde |
mondrian: add transformer scripts for postgres, hsql; fix bugs in SqlQuery; add roadmap. |
||
#2 | 1576 | Julian Hyde |
mondrian: fix dataset (add column customer.ordinal); create dataset for oracle; get queries working on oracle; get format strings working; refactor out new packages mondrian.rolap.agg and mondrian.rolap.sql. |
||
#1 | 1453 | Julian Hyde | mondrian: first source check-in |