Adding FK to a newly attached partition slow
0
votes
1
answer
158
views
We have a partitioned table from which we attach and detach partitions for archiving purposes. When attempting to add a foreign key on the partitioned table, the process is taking a long time (up to 20 minutes) which is causing many problems.
We have discussed using a
NOT VALID
option, but unfortunately this is not an option for partition tables, so just wanted to see if there were any options to add a foreign key to a partition
Asked by Krishnp92
(19 rep)
Jul 16, 2024, 12:50 PM
Last activity: Jul 10, 2025, 10:06 PM
Last activity: Jul 10, 2025, 10:06 PM