XREF output to include the type of lock the query will use and identify partial index usage - OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

What new features or enhancements could improve the OpenEdge Database? Use this challenge to let the OpenEdge team know what would make your life easier by reducing costs and increasing productivity!

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

  • Under Review

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

Comments