September 26, 2008 at 10:11 am
Does anyone have a good step-by-step instruction/book referral on partitioning tables? Possible instructions to create an example on a sample database? The one's I've found are not completely clear. I have the functions created, but do I create the table for each year or is/can this be automatically done? How is the initial move done? Is the current table still used/renamed/deleted? Any help appreciated.
Thanks!
¤ §unshine ¤
September 26, 2008 at 10:16 am
What's wrong with included samples?
September 26, 2008 at 10:20 am
These seem a bit broken up. The 2nd script has no explanation or comments on what the purpose is. Does anyone have any other suggestions? I will continue to look through the different links regarding this.
Thank you.
¤ §unshine ¤
November 4, 2008 at 1:22 pm
Has anyone found good, step-by-step partion instructions? Preferably an example that partitions table into 3 or more???
¤ §unshine ¤
November 4, 2008 at 3:45 pm
November 5, 2008 at 8:57 am
I'll try this one out, thanks!
¤ §unshine ¤
November 5, 2008 at 1:09 pm
Ok. I'm not too familiar with partitioning and here's what I have.
Table1 with millions of rows
I created the quarterly function and schema
I created 4 tables, Table1_20081stQtr on schema
Table1_20082ndQtr on schema
Table1_20083rdQtr on schema
Table1_20084thQtr on schema
I then moved the appropriate data from Table1 to the 4 tables.
Now I'm not sure what I'm supposed to do next.
How will Table1 know to use these tables when users query against Table1? Not sure I understand these instructions. What am I doing wrong???
¤ §unshine ¤
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply