hi every one.
am using sqlserver 2008 R2
i have a few tables with data in those tables increased by 2 crores pluse ,in future it hits more.by that my database performace became very slow, i concentrated on indexing and even on query optimization. still we hitting the same problem.
so i want to use partition technic to overcome this.
i have a doubt for few table am using primary key in were clause and in some table forgien key in where clause.
can any one please suggest if at all we go for partitioning on which columns we need to select .
P.s : all my data in data base is migrated data base.