Why? Update: currently, I'm unable to rebuild this complex view due to SQL constraints. Hence,…