There should be a way to create an index for an already existing table

[orium]

No description provided.

[rpvilao]

Adding on demand or after in general? Because after in general is possible - you just add the new one and if it doesn't exist it will be created.

[orium]

Not sure if I get what on-demand/after-in-general means. In my case I have a table that is created elsewhere (and I don't have access to the entity definition), where I just know that a few columns exist and I want and index on those columns.

[defer]

I can imagine of a few use cases for this like schema migrations.

But, in general, creating and updating DML in different places and with only partial knowledge of of the entity feels wrong.

[rpvilao]

yep it's true. but that would be the approach being wrong and not the feature it self as you said. I don't see any harm to have it. whether it's properly used or not it's a different matter.