Assuming this has been asked but I failed the google.
If I am on cloud and I want to add a new field to a table, can I have that as an indexed column? Is there a process I would take to index it before regen or would I submit a ticket for the request?
How are indexed columns on UD tables defined?
Maybe someone with the Cloud SDK can answer that. Without it, there is no way that I know.
I have an idea out there for it. You might be able to do it with the SDK? But I can’t figure out how it works. When we’ve added our own custom BO’s you can add the indexes in there. But I don’t seem to be able to understand how the SDK works with existing BO’s. Basically, I can see the indexes in the database, but I don’t see the corresponding information in the sdk, so I’m not sure how it would work.
Epicor REALLY needs to bring in a heavy hitter database designer to re-think their indexing strategy. There’s a LOT of unnecessary indexes in database, and it’s a huge performance hit.