MySQL Forums
Forum List  »  Newbie

Fact Table Partition Design
Posted by: rajiv chodisetti
Date: July 15, 2014 11:54AM

Hi ,

I am new to mysql DB and I was an oracle developer earlier .

my question is ,

I have fact tables say "fact_order_item" , with keys defined on
"order_date","product_id","sku_id","inventory_id" etc along with some other 50 columns data and as of now the table is not partitioned .

My question is what is the best way in which we can partition this table , so that the queries hitting this one will get benifited .

and say suppose , i have range partitioned the table on order_date , which partitioning should i apply for the remaining key columns ? , please throw some light on it .


Regards,
Rajiv

Options: ReplyQuote


Subject
Written By
Posted
Fact Table Partition Design
July 15, 2014 11:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.