Question

2
Replies
1364
Views
Lei Zhong (LeiZ4221)
NJ Courts

NJ Courts
US
LeiZ4221 Member since 2016 10 posts
NJ Courts
Posted: April 18, 2017
Last activity: April 26, 2017
Posted: 18 Apr 2017 15:51 EDT
Last activity: 26 Apr 2017 11:05 EDT
Closed
Solved

Is it best practice to create database index for pr_sys_locks?

We have Report to join work object table and pr_sys_locks to show work object as well as locking details, there are millions of records in work table, but pr_sys_locks only has a thousand records. we do have database indexes in work table, is there any benefit to create index for pr_sys_locks table to increase performance?

System Administration Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.