Link to home
Start Free TrialLog in
Avatar of Member_2_6478753
Member_2_6478753Flag for United States of America

asked on

how i can use horizontal partitioning in this tables? s

i have the following table with ID as primary key and msisdn is the user mobile number
and datein as date received the sms and message as sms content and shortcode as the receipt address where mobile users send the sms to it

as following can u  help me how to implement the horizontal partitioning  in this table?

i should always select records by date and by shortcode because i have many shortcodes
and maybe i add new column to this table readflag because sometimes i need to run a trigger to get the content of the sms to process it and like
when user send a code to a shortcode for subscription ...
Avatar of x-men
x-men
Flag of Portugal image

create partition function [My_Part_Function] (date) as range left for values ('2012-11-05',...)
go
Create partition scheme [My_Part_Scheme] as partition [My_Part_Function] TO ([MyFilegroup1], ...)
go
Avatar of Member_2_6478753

ASKER

each day i should create a
create partition function [My_Part_Function] (date) as range left for values ('2012-11-05',...)
go
Create partition scheme [My_Part_Scheme] as partition [My_Part_Function] TO ([MyFilegroup1], ...)
go

create partition function [My_Part_Function] (date) as range left for values ('2012-11-06',...)
go
Create partition scheme [My_Part_Scheme] as partition [My_Part_Function] TO ([MyFilegroup1], ...)
go


and i repeat it for every month? ??
it's not a solution and please try to implement it in my table schema !!!! because it is my first time in partition and i don't now anything about it !
ASKER CERTIFIED SOLUTION
Avatar of x-men
x-men
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial