<div>
<div class="content wysiwyg-content">
I have a view that starts performing slowly when queried via a C# program using LINQ to SQL. &nbsp;The equivalent query executed in management studio performs fine. &nbsp;By equivalent I mean that the SQL code that is created by LINQ to SQL is pasted into management studio and executed.<br />
<br />
After I run sp_refreshview then the LINQ to SQL C# program performs as well as running the query in management studio. &nbsp;There have not been any changes to the schema during this period.<br />
<br />
Any ideas?
</div>
</div>


I have a view that starts performing slowly when queried via a C# program using LINQ to SQL.  The equivalent query executed in management studio performs fine.  By equivalent I mean that the SQL code that is created by LINQ to SQL is pasted into management studio and executed.

After I run sp_refreshview then the LINQ to SQL C# program performs as well as running the query in management studio.  There have not been any changes to the schema during this period.

Any ideas?

SQL Server view query slow until refreshed

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.