Details
L3 - Default Description
Currently, the job acquisition query uses SELECT * to fetch all properties of a job. However, the command currently only requires these columns:
* ID_ * IS_EXCLUSIVE_ * PROC_INST_ID_ * REVISION_
Reducing the select to those columns would allow users to create composite indexes on the columns used in the query such that the query can be answered by index access only.
Furthermore, the command must be able to write LOCK_OWNER_ and LOCK_EXPIRATION_TIME_.