PERFORMANCE ISSUE while inserting bulk data in a blank table from 2 different tables

5 pts.
Tags:
INSERT statement
SQL Server performance tuning
how to improve insert performance in insert into mis_fcr_all_txns_susp_temp (select * from mis_fcr_all_txns_combi a where exists (select acct_no from mis_fcr_all_txns_fraud3 b where a.acct_no = b.acct_no) and a.TXN_DATE BETWEEN (REPORT_DATE - 60) AND (REPORT_DATE - 30));
ASKED: September 18, 2008  1:03 PM
UPDATED: September 18, 2008  6:43 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

What does the execution plan look like?

I would assume that you are missing an index on either or both tables.

How do the indexes look like for these tables?

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Have you tried running just the select statement ? how long does it take to give you the results ? I was just wondering if the performance issue is really at the insertion, or it is related to the query that provides the data to insert.
    65,110 pointsBadges:
    report
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    65,490 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following