Checked the cause of too much time in generating of Layer 2 Fused Data Refresh, as per checked reason is the deleting query of CSHDET joined to CSHDETF. We are monitoring and making a solution to resolve this problem