The Distribution of Values button used for fields with a defined LOV while building a Query activity has regularly taking more than a couple minutes to load the LOV or (more often) gets stuck in a hung state (loading list). If the user doesn't click Cancel then this results in an error.
The Targeting dimension and Filtering dimension are different schemas. Is it because of that, this loading time is more? The issue is coming in Production environment and the Distribution of Values is loading within 20 seconds in Stage environment.
Could someone please help us figure out the issue and resolve it.