ETL/LNV processing gets stuck intermittently.

The issue occurs only on the first execution for a new AS_OF_DATE.

Subsequent executions for the same AS_OF_DATE complete much faster.

The problem is not tied to a single query; different queries have exhibited the behavior.