Hello
I have a view A which has been split into 2 separate views B and C
View C takes 2 secs to run
View B takes 6 secs to run
Main View A is taking 32 mins to run.ive run a Display Estimated Execution Plan. nothing been suggested like indexes or anything . also mot of the Cost is 0% or 1% . cant see anything costing the query to run slow
I have a view A which has been split into 2 separate views B and C
View C takes 2 secs to run
View B takes 6 secs to run
Main View A is taking 32 mins to run.ive run a Display Estimated Execution Plan. nothing been suggested like indexes or anything . also mot of the Cost is 0% or 1% . cant see anything costing the query to run slow