Minaz Amin (1/7/2013)
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