Question

2
Replies
1339
Views
LeiZ4221 Member since 2016 10 posts
NJ Courts
Posted: April 18, 2017
Last activity: April 26, 2017
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
Share this page LinkedIn