MySQL Forums :: Newbie :: Fact Table Partition Design

Advanced Search

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 .


Options: ReplyQuote

Subject Written By Posted
Fact Table Partition Design rajiv chodisetti 07/15/2014 11:54AM
Re: Fact Table Partition Design Rick James 07/16/2014 10:22PM
Re: Fact Table Partition Design peter scot 07/16/2014 11:18PM
Re: Fact Table Partition Design Rick James 07/17/2014 04:09PM

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.