Posted by ysfinks on 03/09/06 23:30

I compared view query plan with query plan if I run the same statement
from view definition and get different results. View plan is more
expensive and runs longer. View contains 4 inner joins, statistics
updated for all tables. Any ideas?

• Next in forum: Re: Optimization jobs - transaction deadlock victim
• Prev in forum: Re: Optimization jobs - transaction deadlock victim
• Thread view: Different query plans for view and view definition statement

[Reply to this message]