|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
View prevents stored procedure from caching execution plan?Hello
SQL Server 2000 SP4 According to the books View's execuion plan is recalculated each time the view is accessed. Does it mean that if stored procedure queries data from a view, possibly filtering output with WHERE clause its own execution plan will also be recalculated each time? Thanks in advance. Plan caching against a view work the same way as if you queried the table directly. It doesn't
matter if you execute the queries from a stored procedure or not. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Alexander Korol" <AlexanderKo***@discussions.microsoft.com> wrote in message news:CCEA6612-775C-4C7A-B8AC-A41F3F90938C@microsoft.com... > Hello > > SQL Server 2000 SP4 > > According to the books View's execuion plan is recalculated each time the > view is accessed. Does it mean that if stored procedure queries data from a > view, possibly filtering output with WHERE clause its own execution plan will > also be recalculated each time? > > Thanks in advance.  |
|||||||||||||||||||||||
Other interesting topics