SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to partition data of huge table


How to partition data of huge table

Author
Message
av.abhishek
av.abhishek
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 20
I have a table(T1) of around 20 million record and about to grow in future by 100 to 200%. It contains the Data for the respective day and on next day it will be stored into another table (backup tables (T1_Backup)). And the process continues.

My queries are
1) T1 table is used to generate report for the respective date. I am thinking to partition the table with respective to category column (which is varchar datattype).

2) T1_Backup table is also containing data of each date with category which grows rapidly. To retrieve data from the table it is consuming lot of time.

Let me know the process of partitioning with respective of category for T1 table and for T1_Backup wrt to date and category.
Rajat Jaiswal-337252
Rajat Jaiswal-337252
Old Hand
Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)

Group: General Forum Members
Points: 391 Visits: 398
Hi Abhishek,

I am assuming the mail target of this partition is to fetch the query fast.

So use those values which are frequently used in your Where clause.

You can use Date column or Year column also for this.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search