XREF output to include the type of lock the query will use and identify partial index usage

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

ed_o_s

Guest
XREF output to include the type of lock the query will use and identify partial index usage Currently the XREF output is extremely useful to determine index usage for queries and determine any potential full table scan. Suggested Enhancement: Add details of the lock type to the XREF Output 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. Suggested Enhancement: Identify queries that only have a partial index match Current if your query matches 2 of the 3 fields say in an index it wont show up as a WHOLE-INDEX scan in XREF. This can lead to inefficient queries so it would be good to output in XREF the queries that only have a partial index match

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