Maybe there is a missing index.
I made all the indexes but eye balling it.
That's' why I asked earlier if there is a compare two objects.
It would be awesome if the ATTACHED said what it was doing, what was missing
On Thu, May 11, 2023 at 3:14 PM Jeff Janes <jeff.janes@xxxxxxxxx> wrote:
On Thu, May 11, 2023 at 3:06 PM kyle Hailey <kylelf@xxxxxxxxx> wrote:I created a constraint to make the ATTACH command work immediatelyYou also need to create any indexes which exist on the parent table onto the incoming partition, otherwise they will need to be created during the attach operation.Cheers,Jeff