Posted by ysfinks on 10/01/25 11:42

View was created from Query Analyzer. If I remove nolock - same result.
Another fact - if I change condition value in where clause, for some
values it gives for the view the good query plan using index for
eccrootid.
For the query simulating the view - always good plan.

• Next in forum: views dependent on other views
• Prev in forum: Re: 2005 Database Mirroring & Witness
• Thread view: Re: Different query plans for view and view definition statement

[Reply to this message]