SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Can Collocation be helpfullin following situation.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rajemessage
Starting Member

17 Posts

Posted - 12/06/2013 :  02:36:32  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000