Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with View
Message
De
11/10/2013 00:34:11
 
 
À
11/10/2013 00:29:43
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:
01585242
Vues:
44
If I understand your question.....

You can redirect the results of the view into a table like this...

Select * into #Temp from vwSalesResults

Obviously, that won't solve the original problem.

I have a couple of theories on what the problem might be, but would like to see the 2 execution plans and information about the tables.

One question to ask for right now - how often are the indexes on the tables recreated, and how often are the statistics on the tables updated? (i.e. is there an overnight job to reindex, update statistics, etc.)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform