nick.mcdermaid (2/6/2013)
Those are very general benefits but it sounds like you've convinced yourself anyway.
Honestly speaking database design is under physical design phase so cant tell whether my approach is good or not ? thats the reason i posted the question here.
nick.mcdermaid (2/6/2013)
If you are talking about having a seperate detail and summary table then it's not vertical partitioning because it isn't a 1:1 relationship.
i didnt get this , please explain .what i inderstand here is for every claimID from claim table there must be a record in claim_summary table.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)