Home › Discussions › Questions & Answers › Optimizing Slow List of Values in Blitz Reports
Customer · · Questions & Answers · 5 replies
We imported many reports from Discoverer, and now some of our LOVs are extremely slow. How can I quickly find and validate all the LOV SQL queries for valid syntax and look for performance issues?
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.
If the SQL syntax is valid but the LOV is still slow, what common optimization hint should I look for, especially concerning migrated reports?
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.
If I notice multiple parameters using identical Custom LOV queries, how can I consolidate them to simplify maintenance and ensure consistency?
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.
Sign in with LinkedIn or Google to take part.
