Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with View
Message
De
11/10/2013 08:24:57
 
 
À
11/10/2013 01:25:54
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2008 R2
Application:
Desktop
Divers
Thread ID:
01585239
Message ID:
01585257
Vues:
42
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform