question

anaghaDBA avatar image
anaghaDBA asked

Partitioning using Lookup function

We want to create a partition for master table on cut-off_date column. But the child tables do not have this cut-off date column. They have an ID column. The child tables are linked to master tables through another bridge table & this bridge table includes the ID column & Cut-off_Date column. Now we want to Partition the child tables also based on the cut-off date but since there is no direct mapping of cut-off_date of Master Table with child table, can we create a partition on child tables using some look-up function(which will be referring to one of the tables) without adding any extra column of cut-off_date in the child tables. We want to know any possible methods that will not involve any schema changes on the DB. Please suggest in case of any other better approaches.
partitioningpartition
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
west007 avatar image
west007 answered
I recomend to rethink the desired design Regards
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
It looks like they are open to guidance - is there anything specific they should consider while rethinking the design?
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.