troubleshooting Question

optimize view to prevent the transaction log from being filled

Avatar of bibi92
bibi92Flag for France asked on
Microsoft SQL Server
15 Comments1 Solution94 ViewsLast Modified:
Hello,

How can I optimize the following view to prevent the transaction log from being filled

CREATE VIEW ZONE_QTE
AS
SELECT *  FROM US.QTE
Union ALL
SELECT * from  EU.QTE
Union ALL
SELECT * from  ASI.QTE


INSERT INTO WORLD.QTE with (tablock)
            SELECT [QTE_QRL_LB_EBELN]
                    
              FROM ZONE_QTE
              WHERE [QTE_QRL_LB_EBELN] like '55%' and [QTE_QRL_LB_BUS_TRAN] = 'GR'

Thanks

regards
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros