Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with View
Message
From
11/10/2013 08:24:57
 
 
To
11/10/2013 01:25:54
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008 R2
Application:
Desktop
Miscellaneous
Thread ID:
01585239
Message ID:
01585257
Views:
43
OK, thanks. Also, can you post the code for the view itself? That would help as well.

Two things...first, is the view using OPENQUERY and/or a Linked Server? Judging from the execution plan, it might be.

Second, I see many table scans in the execution plan. I'm wondering if the view is combining data from a linked server with local tables, and the local tables have no indexes at all. Can't tell for certain, that's why seeing the code and indexes on tables like SalesRepUserName, CustomerCodes, and VCMK_Contact would be helpful.
Previous
Reply
Map
View

Click here to load this message in the networking platform