Optimizing Slow List of Values in Blitz Reports

You should use the Blitz Report LOV SQL Validation report. This report specifically validates Blitz Report LOV SQLs for valid syntax, which is crucial after mass migrations from tools like Discoverer.

After migration, often slow LOVs contain `distinct` clauses which hinder performance. The recommendation is to correct errors and change slow ‘distinct’ style queries to faster SQL statements.

Run the Blitz Report Parameter Custom LOV Duplication Validation report. It identifies custom LOVs with the same query used more than once, suggesting they should be converted and set up as a shared LOV instead.