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?
I do not think creation of index on pr_sys_locks table will be a good idea. pr_sys_lock table will only have entries if somebody is working on a case. So, compared to case table the no of records in pr_sys_locks table is minimal. Hence rather than creating a separate index table, just make sure to create indexes on the column for both the tables which will be used to join on.So, create index on pzInsKey column of pr_sys_locks table(I think this might already be present).For work table it will automatically be present.