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

[VeerSingh2]

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 solution]

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.

[VeerSingh2]

Got it, thank you John