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

03121980

5 pts.

Tags:

INSERT statement

SQL Server performance

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 Last updated: September 18, 2008 6:43 PM

Answer Wiki

Last updated: September 18, 2008 6:43 PM GMT

Denny Cherry68,410 pts.
History
Contributors
- Ordered by most recent
- Denny Cherry68,410 pts.

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

carlosdl Sep 18, 2008 3:10 PM GMT

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.

84,495 pointsBadges:

report
Denny Cherry Sep 18, 2008 6:43 PM GMT

Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.

68,410 pointsBadges:

report