Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajemessage
Starting Member
17 Posts |
 Posted - 2013-12-06 : 02:36:32
|
Hi,
I was trying to partition my tables , and also read about Collocation.
q1) I would like to know whether i will get benefit of Collocation in following situation or not.
q2) Should i make clusterd index on partition key Pid
q3) will it get benefit from partitioning.
I have a table "A" and "B" with many columns and it has one Partition key Pid with is not unique.
with in a table Pid repeates 3 or 4 times.
Both are partitioned, since the partition key is not unique.
so at many places i have to use following query.
1) Select * from A
join (select Distinct pid , tname from B) B1
on A.pid = B.pid
where ......
2) Select * from A
where exist (select pid , tname from B
on A.pid = B.pid
)
yours sincerly |
|
|
|
|
|
Can Collocation be helpfullin following situation.