Reply to Different query plans for view and view definition statement
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?