Select to view content in your preferred language

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

346
2
Jump to solution
06-12-2023 06:15 AM
VeerSingh2
New Contributor III

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

0 Kudos
1 Solution

Accepted Solutions
JohnAlsup
Esri Contributor

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.

John Alsup
jalsup@esri.com

View solution in original post

0 Kudos
2 Replies
JohnAlsup
Esri Contributor

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.

John Alsup
jalsup@esri.com
0 Kudos
VeerSingh2
New Contributor III

Got it, thank you John

0 Kudos