Forum Post: XREF output to include the type of lock the query will use

  • Thread starter Thread starter ed_o_s
  • Start date Start date
Status
Not open for further replies.
E

ed_o_s

Guest
Currently the XREF output is extremely useful to determine index usage for queries and determine any potential full table scan. An excellent addition to this would be if the output also include the lock status the query would use (NO-LOCK, EXCLUSIVE, SHARE-LOCK). This would provide information at compile time to check for default SHARE locks in the code that may have been overlooked. It would help prevent locking issues at development time.

Continue reading...
 
Status
Not open for further replies.
Back
Top