https://community.esri.com/t5/arcgis-utility-network-questions/is-it-ok-to-create-index-on-column-registration-id/m-p/1298036#M2551 <P>Got it, thank you John</P> Mon, 12 Jun 2023 13:29:28 GMT VeerSingh2 2023-06-12T13:29:28Z https://community.esri.com/t5/arcgis-utility-network-questions/is-it-ok-to-create-index-on-column-registration-id/m-p/1298022#M2549 <P>hello Guys,</P><P>some time we there is situation of long running queries like geoprocessing work/edit work flow. by which application gets slow from database perspective.</P><P>There is thought that</P><P>&nbsp;Is it ok to create index on column <STRONG>registration_id</STRONG> in table "<STRONG>SDE_table_locks</STRONG>" for long running queries&nbsp; to makes the performance better.</P><P>Please advise me on this.</P><P>thanks</P><P>VPS</P> Mon, 12 Jun 2023 13:15:43 GMT https://community.esri.com/t5/arcgis-utility-network-questions/is-it-ok-to-create-index-on-column-registration-id/m-p/1298022#M2549 VeerSingh2 2023-06-12T13:15:43Z https://community.esri.com/t5/arcgis-utility-network-questions/is-it-ok-to-create-index-on-column-registration-id/m-p/1298032#M2550 <P>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.</P> Mon, 12 Jun 2023 13:24:50 GMT https://community.esri.com/t5/arcgis-utility-network-questions/is-it-ok-to-create-index-on-column-registration-id/m-p/1298032#M2550 JohnAlsup 2023-06-12T13:24:50Z https://community.esri.com/t5/arcgis-utility-network-questions/is-it-ok-to-create-index-on-column-registration-id/m-p/1298036#M2551 <P>Got it, thank you John</P> Mon, 12 Jun 2023 13:29:28 GMT https://community.esri.com/t5/arcgis-utility-network-questions/is-it-ok-to-create-index-on-column-registration-id/m-p/1298036#M2551 VeerSingh2 2023-06-12T13:29:28Z