statsics look real bad in two of the queries (200K+ rows estimated, actual = 0

and pretty bad for the rest;

running this, with no other changes, will at least help a little bit: the otehr items should be addresses ASAP.

USE [MICGHBI_UAT_EDW];

UPDATE STATISTICS [dbo].[AGNT_MFS_CL_FCT] WITH FULLSCAN;

UPDATE STATISTICS [dbo].[AGNT_MFS_CL_FCT] WITH FULLSCAN;

UPDATE STATISTICS [dbo].[AGNT_MFS_PRFL_DIM] WITH FULLSCAN;

UPDATE STATISTICS [dbo].[AGNT_MFS_SVC_ACCM_FCT] WITH FULLSCAN;

UPDATE STATISTICS [dbo].[AR_MFS_CL_FCT] WITH FULLSCAN;

UPDATE STATISTICS [dbo].[AR_MFS_CL_FCT] WITH FULLSCAN;

UPDATE STATISTICS [dbo].[AR_MFS_PRFL_DIM] WITH FULLSCAN;

UPDATE STATISTICS [dbo].[AR_MFS_SVC_ACCM_FCT] WITH FULLSCAN;

UPDATE STATISTICS [dbo].[AR_ST_DIM] WITH FULLSCAN;

UPDATE STATISTICS [dbo].[DT_DIM] WITH FULLSCAN;

UPDATE STATISTICS [dbo].[DT_DIM] WITH FULLSCAN;

UPDATE STATISTICS [dbo].[PYMNT_ENTTY_DIM] WITH FULLSCAN;