Everyone my office is complaining about slow views whilst the view tkae a long time to return what is the best way to approach this tuning nightmare.
thanks in advance
Printable View
Everyone my office is complaining about slow views whilst the view tkae a long time to return what is the best way to approach this tuning nightmare.
thanks in advance
A view is nothing more than a stored query. Tune the underlying query and your view will be tuned.
Jeff is totally right. It might also be good to afterwards look at how much data they're returning.