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.
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
Xref only includes some static querys all so it is pretty much useless for a full analysis for static queries
i made a suggestion for a new compilerswitch that outputs information on all static queries:
This new file should also include this ida!
This idea belongs under OpenEdge Development, not OpenEdge Database.
fixed link to the related idea: