<div>
what takes the time <br />
the select into <br />
or the update ?<br />
<br />
which version of sql server?<br />
<br />
why isn't the maestrocampaignlist in the warehouse?<br />
<br />
why do you need to &nbsp;datediff on campaigndate?<br />

</div>


what takes the time
the select into
or the update ?

which version of sql server?

why isn't the maestrocampaignlist in the warehouse?

why do you need to  datediff on campaigndate?


<div>
create this index it will speed upd the process a bit.
</div>


create this index it will speed upd the process a bit.

<div>
<div class="content wysiwyg-content">
Hello,<br />
I am running a query which takes about one hour.Can any one help me optimize it.<br />
Here is the query:<br />
<br />
Select * into #TAD &nbsp;from<br />
OPENQUERY(DWDB, 'select DW_PR_SVC_LOAN_ID,DELQ_PRI<wbr />N_AMT <br />
as Total_Amt_Due from DW_PR_SVC_LOAN_MOD ')<br />
<br />
Update &nbsp;tbl_MaestroCampaignList set TotalAmountDue = #TAD.Total_Amt_Due<br />
from (tbl_MaestroCampaignList inner join #TAD<br />
on tbl_MaestroCampaignList.DW<wbr />_PR_SVC_LO<wbr />AN_ID = #TAD.DW_PR_SVC_LOAN_ID)<br />
where<br />
datediff(day,GetDate(),cam<wbr />paignDate)<wbr />=0 and CampaignName ='FirstLienPreFCL'<br />
<br />
I have to basically calculate Total Amount only for the loans in tbl_MaestroCampaignList .But I have to get these values from Datawarehouse table which has about a million loans. How to optimize it.<br />
Thanks &nbsp;bunch
</div>
</div>


Hello,
I am running a query which takes about one hour.Can any one help me optimize it.
Here is the query:

Select * into #TAD  from
OPENQUERY(DWDB, 'select DW_PR_SVC_LOAN_ID,DELQ_PRIN_AMT 
as Total_Amt_Due from DW_PR_SVC_LOAN_MOD ')

Update  tbl_MaestroCampaignList set TotalAmountDue = #TAD.Total_Amt_Due
from (tbl_MaestroCampaignList inner join #TAD
on tbl_MaestroCampaignList.DW_PR_SVC_LOAN_ID = #TAD.DW_PR_SVC_LOAN_ID)
where
datediff(day,GetDate(),campaignDate)=0 and CampaignName ='FirstLienPreFCL'

I have to basically calculate Total Amount only for the loans in tbl_MaestroCampaignList .But I have to get these values from Datawarehouse table which has about a million loans. How to optimize it.
Thanks  bunch

Optimizing TSQL query

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.