Is it ok to create index on column registration_id in table "SDE_table_locks" for long running queries

Question

hello Guys,

some time we there is situation of long running queries like geoprocessing work/edit work flow. by which application gets slow from database perspective.

There is thought that

Is it ok to create index on column registration_id in table "SDE_table_locks" for long running queries  to makes the performance better.

Please advise me on this.

thanks

VPS

JohnAlsup · Accepted Answer

It's unlikely it would help any and has the potential to degrade performance due to the updates of the index that occur on the creation and deleting of locks.