January 7, 2013 at 1:44 am
Hi All,
We are planning to partition our table which have many reference tables. Is it possible to have multiple keys as partitons keys?
"More Green More Oxygen !! Plant a tree today"
January 7, 2013 at 3:30 pm
Minaz Amin (1/7/2013)
Hi All,We are planning to partition our table which have many reference tables. Is it possible to have multiple keys as partitons keys?
No. You only designate one partition key but you can have additional unique constraints which you can then refer to by foreign key.
Just curious, why are you planning to partition your table?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 7, 2013 at 10:48 pm
My table is huge and get lncremented to 10 - 20 GB in a week so we were planning to partition the table on date range weekly and push the the last old data to archive toother DB or tape.
"More Green More Oxygen !! Plant a tree today"
January 7, 2013 at 11:36 pm
Minaz Amin (1/7/2013)
Is it possible to have multiple keys as partitons keys?
let me guess it is because "to cover most of the queries" ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply