Audit database indexes vs oml indexes

Audit database indexes vs oml indexes


I would like to know if there is a way to map the oml index name to the database index name.
I got the espace indexes from outdoc xml generated and database indexes from a TSQL script.
Now i would like to identify which of them are only created in the database.
Thank you.

Hi Pedro,

The platform should be generating a compile time warning when that happens saying that there are custom indexes that are not in the model.

As for the question itself, I don't remember if the outdoc lists the attributes of each index. If it does, you will need to match the attributes (in order) to the ones from your query.

João Rosado