Can not create index

[Jinye Gao]

Hi guys

There are some indexes in a table, and I want to create another one which is a set of three columns: [u_commoncustomerid, u_contractstartdate, u_contractenddate].

Platform shows me that was scheduled, but it was never shown in the [Tables & Columns].

Does anyone see this before? any ideas?

[Sagar Pagar · Accepted solution]

Hi,

Depending on the size of the table, the index creation can take anything from a few seconds to hours, or days.You can check the index after some time.

Remember to test the index creation on a sub-production instance first!

Take a look at this kb -  How to create a database index via the UI

Thanks,
Sagar Pagar