SELECT CRF1.[BRANCH_CO_MNE] AS [BRANCH_CO_MNE]
,CRF1.[ASSET_TYPE] AS [ASSET_TYPE]
,CRF1.[MIS_DATE] AS [MIS_DATE]
,CRF1.[Sys_Line_Id] AS [GL Line Number]
,CRF1.[Sys_Product] AS [Category]
,CRF1.[CUSTOMER] AS [CUSTOMER]
,CRF1.[CURRENCY] AS [CURRENCY]
,CUS1.[NAME_1] AS [Customer Name]
,CRF1.[VALUE_DATE] AS [VALUE_DATE]
,CRF1.[LINE/CONTRACT] AS [LINE/CONTRACT]
,CRF1.[MAT_DATE] AS [MAT_DATE]
,insight.dbo.ufn_SplitLocalRef(CUS1.LOCAL_REF,49) AS [RZB_CUST_SEGMENT]
,CRF1.[CURRENCY_AMT] AS [CURRENCY_AMT]
,CRF1.[LOCAL_CCY_AMT] AS [LOCAL_CCY_AMT]
,
(right(insight.dbo.ufn_splitlimitref(LIMIT1.LIMIT_ID,2),4)+'.'+insight.dbo.ufn_splitlimitref(LIMIT1.LIMIT_ID,3) ) AS LIMIT_REFERENCE 存储过程
FROM [Insight_BNK_10911].dbo.[FACT_SYS_RE_CRF_GL] AS CRF1
Left Outer Join [Insight_BNK_10911].dbo.[FACT_BNK_CUSTOMER] AS CUS1 ON CRF1.Surrogate_Customer_PK = CUS1.Surrogate_id AND CRF1.Partition = CUS1.Partition
LEFT OUTER join [Insight_BNK_10911].dbo.[DIM_BNK_CUSTOMER_LIMITS] as LIMIT1 on CUS1.RECORD_KEY = LIMIT1.Sys_Parent_Liability AND CUS1.[Partition]= LIMIT1.[Partition]
WHERE ( ([CUS1].[Partition] = '30' Or [CUS1].[Partition] Is Null)) AND (CRF1.BRANCH_CO_MNE <> '')
如何使这个效率提高,现在才1w就37秒,同时帮我看下逻辑,我觉得有问题
从3个表取值 LIMIT_REFERENCE是来自DIM_BNK_CUSTOMER_LIMITS
,CRF1.[ASSET_TYPE] AS [ASSET_TYPE]
,CRF1.[MIS_DATE] AS [MIS_DATE]
,CRF1.[Sys_Line_Id] AS [GL Line Number]
,CRF1.[Sys_Product] AS [Category]
,CRF1.[CUSTOMER] AS [CUSTOMER]
,CRF1.[CURRENCY] AS [CURRENCY]
,CUS1.[NAME_1] AS [Customer Name]
,CRF1.[VALUE_DATE] AS [VALUE_DATE]
,CRF1.[LINE/CONTRACT] AS [LINE/CONTRACT]
,CRF1.[MAT_DATE] AS [MAT_DATE]
,insight.dbo.ufn_SplitLocalRef(CUS1.LOCAL_REF,49) AS [RZB_CUST_SEGMENT]
,CRF1.[CURRENCY_AMT] AS [CURRENCY_AMT]
,CRF1.[LOCAL_CCY_AMT] AS [LOCAL_CCY_AMT]
,
(right(insight.dbo.ufn_splitlimitref(LIMIT1.LIMIT_ID,2),4)+'.'+insight.dbo.ufn_splitlimitref(LIMIT1.LIMIT_ID,3) ) AS LIMIT_REFERENCE 存储过程
FROM [Insight_BNK_10911].dbo.[FACT_SYS_RE_CRF_GL] AS CRF1
Left Outer Join [Insight_BNK_10911].dbo.[FACT_BNK_CUSTOMER] AS CUS1 ON CRF1.Surrogate_Customer_PK = CUS1.Surrogate_id AND CRF1.Partition = CUS1.Partition
LEFT OUTER join [Insight_BNK_10911].dbo.[DIM_BNK_CUSTOMER_LIMITS] as LIMIT1 on CUS1.RECORD_KEY = LIMIT1.Sys_Parent_Liability AND CUS1.[Partition]= LIMIT1.[Partition]
WHERE ( ([CUS1].[Partition] = '30' Or [CUS1].[Partition] Is Null)) AND (CRF1.BRANCH_CO_MNE <> '')
如何使这个效率提高,现在才1w就37秒,同时帮我看下逻辑,我觉得有问题
从3个表取值 LIMIT_REFERENCE是来自DIM_BNK_CUSTOMER_LIMITS
回复内容太短了!
帮忙up下。