On Fri, Sep 1, 2023 at 2:58 PM richard coleman <rcoleman.ascentgl@xxxxxxxxx> wrote: > > The schema is just fine. When loading large amounts of data, some tables are greater than a terabyte in size, you typically don't have keys or indices until after it finishes as that slows things down. > I am not talking about two or three tables, but hundreds of tables. It's a rather labor intensive option for want of a IF NOT EXISTS clause. Well, I see the scope for tools like sqitch here. Also because testing the existence of the index, in your particular case, is one small step. What happens if the index has been invalidated somehow? You will see an existing index that is unusable, and this could happen also with a fantomatic "IF NOT EXISTS" behavior, so it sounds to me you need something even more smarter. Luca
