June 23, 2011 at 2:07 am
please some one help me, I have a sales table which has nearly 30 million records I want to paration this table and I know well how can I paration it but my question what is the best flow of events I can follow to do that parationing fast and well
June 23, 2011 at 2:22 am
What kind of data is stored in the table ,
Mainly is it a product table with 30 millions rows for 30 million products,
Or is it a time based fact table or id based fact table.
If your using a product table then basically u want the entire table queryable (i.e all 30 million rows)
If your using a fact table with a time series or some kind of id then u want to see the interval at which you want query able data .
for example should all data for latest one year be in a single partition etc.
For the product example your options are a bit limited unless you can use a function that identifies the input and and directly look up the right partition, an approach would be alphabetically sort and partition based on the product desc etc.
June 23, 2011 at 2:43 am
for each product there are many sales records, and there are 2 types of sales in and out, data in sales table uploaded monthly so I prefered to partation my table per month, till now i cannot create a paration, I want to know what is the best way of creating patartions, try creating parations while data is inside the table or create new table with the same structure then paration it then upload data inside.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply